## SUM Function in Excel

Sum function in excel is an inbuilt function which is used to sum numerical values present in a range of cells, it is a mathematical formula in excel which can be used by typing =SUM( keyword in the cell where we want the sum to be calculated and then we select the range of cells which are to be added.

### Formula

The SUM Formula accepts the following parameters and arguments:

**Number- **A numeric value that you wish to sum. Number1 is required and Number2 till Number_n is optional. You can add up to 255 arguments.

**Cell**– The range of cells which you wish to sum. The first range of cells i.e. cell1:cell2 is required. Cell3:Cell4 and so on are optional.

**Return Value: **The Sum Function in Excel returns the sum of values supplied. The return value is a numeric value.

### Constraints

The SUM function has the following constraints while using –

- The mappings dimensions must be the dimensions of the source line item.
- The resulting line must be number-formatted always.

### Usage Notes

- The Sum Function sums all the values which are supplied as arguments and up to 255 arguments.
- These arguments supplied in the SUM formula can be numbers, arrays, cell references, arrays, constants and the results of other functions or formulas.
- For example, SUM (B1:B3) adds all the numbers which are present in the cells B1 through B3, which equals to the return value of SUM (B1, B2, B3).

### Nesting Functions in Formulas

The Excel’s built-in formulas can be expanded, if you nest one or more functions inside some another function in a formula. The effect of these nesting functions will permit multiple calculations for taking place in a single worksheet cell. For doing this, the nested function acts as one of the arguments for the main or the outermost function.

For example, let’s nest the SUM function inside the ROUND function.

4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

Excel will execute the deepest or the innermost function first and then will go outwards. For the above formula, the result will be –

- Find the sum of the value in cells A1 to A6.
- Round this result in three decimal places.

A total of 64 levels of nested functions are permitted since Microsoft Excel 2007. Before this version, only 7 levels of nested functions were allowed to use.

### Steps to Open the SUM Function in Excel

- You can simply enter the desired SUM formula in the required cell to attain a return value on the argument.
- You can manually open the SUM formula dialogue box in the spreadsheet and enter the values to attain a return value.
- To open the SUM formula dialogue box, go to the ‘Math & Trig’ option under the Formulas Section in the Menu Bar. Consider the screenshot below.

- Click on the “Math & Trig’ tab. A drop-down menu will open up, from which you have to select the SUM option. See the screenshot below.

- Once you click the SUM option, the SUM function arguments dialogue box will open, where you can put the arguments and attain a return value for Excel SUM function. Consider the screenshot below.

### The AutoSum Option in Excel

The quickest way to add up the numbers in a range of cells is to use the AutoSum button. It will automatically enter a SUM function in the selected cell.

The SUM will total one or more than one numbers in a range of cells. Let’s see the method below.

- Select the blank cell in the row below the cell which you need to sum, cell A8 in the below SUM Function example.

- Now, click AutoSum command on the Home tab. You can also use the keyboard shortcut: Alt + =.

- You can see that an Excel SUM formula will be appearing in the active cell, with reference to the cells above.

- You can press the Enter key to complete the entry. See the screenshot below.

### How to Use SUM Function in Excel (with Examples)

Let’s look below at some of the examples of SUM function on Excel. These Excel Sum Function examples will help you in exploring the use of SUM function in Excel.

#### Example #1

When the Excel SUM formula is written is =SUM (A2, A3)

**Result: **

Consider the excel spreadsheet below.

#### Example #2

When the Excel SUM formula is written is =SUM (A3, A5, 45)

**Result:**

You can see the excel spreadsheet below.

#### Example #3

When the Excel SUM formula is written is =SUM (A2:A6)

**Result:**

Consider the excel spreadsheet below.

#### Example #4

When the Excel SUM formula is written is =SUM (A2:A3, A5:A6)

**Result:**

You can see the excel spreadsheet below.

#### Example #5

When the Excel SUM formula is written is =SUM (A2:A3, A5:A6, 500)

**Result:**

Consider the excel spreadsheet below.

### Things to Remember

- #VALUE! Error – It occurs when the criteria provided by you is a text string which is more than 255 characters long.
- The easiest way for applying the SUM function is that you can simply select a cell next to the numbers which you need to add and click on AutoSum on the Home tab. You can then press the Enter key and the Excel SUM formula will be inserted automatically.

### SUM Function in Excel Video

### Recommended Articles

This has been a guide to SUM Function in Excel. Here we discuss the SUM Formula in excel and how to use SUM in Excel along with excel SUM Function examples and downloadable excel templates. You may also look at these useful functions in excel –

- SUMIFS with Multiple Criteria
- SUMX in Power BI
- TEXT Function
- Concatenate Excel Function
- Excel Alternate Row Color

- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion