Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a given range. Here you should know about “Excel Ranges” before starting to use Excel Formulas.
You can SUM (Add) multiple numbers in a given range of excel and get the total amount with just few clicks. So Let’s learn this most basic Excel formula
Â
1.  =SUM(Range1,Range2……)
2. =SUM(Range1,Range2……)
3. =SUM(Range Start:Range End) i.e. =SUM(A2:A4)
This formulas can be used to calculate the total of any range/cell reference given in excel. We can use multiple range to find the Total/Sum of given values or we may enter/select values to get the total.
So if you do simple math 2+2=4, you may use this formula to do the same in excel
Things To Remember
 – This formula should strictly be used with Numbers only
 – If this formula is showing  #Ref error, it means that you have deleted or added a Row
 – If this formula is showing #N/A error, it means that your range might contain text
All above mentioned formulas are using the relative references which means that these are dynamic ranges, so if you copy these formulas or paste it somewhere else or drag in rows or columns, ranges will be automatically updated relatively.
So when your Excel Ranges are fixed, you should make excel ranges Fixed/Absolute range. In order to make excel ranges absolute, you can fix those excel range by putting “$” i.e. if you want to fix the columns only, you should use
=Sum($A2:$A10) >> Here we are fixing the column "A" or
=Sum(A$2:A$10) >> Here we are fixing the Rows by putting $ front of 2 and 10
=Sum($A$2:$A$10) >> Here we are fixing both Rows and Columns by putting $
Blank rows in Excel can be a real hassle, making it harder to move around and work with your data. But don’t worry—there are plenty of easy ways to get rid of these unwanted rows….
Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
What is Excel Tables? Excel tables organize data into rows and columns with special features like unique names for columns, easy-to-use formulas, automatic formatting, and simple sorting and filtering. They make data management and analysis…
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
How to use the compound interest formula in Excel and gives examples of how to calculate the future value of an investment with yearly, monthly, or daily interest. It also shows you step-by-step how to make your own Excel compound interest calculator.
In this tutorial, we’ll learn how to convert inches to Centimeters, and millimeters. A millimeters is one-tenth of a centimeter. You can easily do these conversions in Excel using formulas. Let’s see how it works.