# SUM Function in Excel

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

### Sum Function Syntax:

`1.  =SUM(Range1,Range2……)`
`2.  =SUM(Range1,Range2……)`
`3.  =SUM(Range Start:Range End) i.e. =SUM(A2:A4)`

## When should we use the SUM Function?

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

## Methods For Sum Function   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 \$`

You can also practice this through our practice files. Click on the below link to download the practice file.

## Recommended Articles

### Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

### Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.