Excel Functions Tutorials

- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- DSUM
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- Excel Matrix Multiplication
- Excel Minus Formula
- FLOOR Function in Excel
- Histogram Formula
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- Mode in Excel
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- PRODUCT Formula in Excel
- PI in Excel
- Quotient in Excel
- Running Total in Excel
- RAND Excel Function
- Rand Excel Formula
- RANDBETWEEN in Excel
- MROUND in Excel
- ROUND in Excel
- ROUND Formula in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUM Formula in Excel
- Excel SUM Shortcut
- SUMIF in Excel
- SUMIFS in Excel
- SUMIF Not Blank
- SUMIFS with Dates
- SUMIF Between Two Dates
- Sumif Text in Excel
- SumIf with Multiple Criteria
- SUMPRODUCT Function in Excel
- SUMPRODUCT Formula in Excel
- SUMPRODUCT with Multiple Criteria
- How to Sum Multiple Rows in Excel?
- TAN Excel Function
- TANH in Excel
- Average vs Weighted Average

- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)

Related Courses

**SUM Function on Excel (Table of Contents)**

- SUM Function
- Excel SUM Formula
- Constraints
- Usage Notes
- Nesting Functions in Formulas
- How to Open the SUM Function?
- The AutoSum Option in Excel
- How to Use SUM Function?

## SUM Function in Excel

The SUM in Excel is a built-in function which adds all the numbers in the range of cells and returns the result of the addition. It is categorized as a Math/Trig Function in Excel. The Sum Function can be used as a worksheet function and can be entered as a part of a formula in a cell of the worksheet. The Sum function will return the sum of the values which are entered as multiple arguments. A total of 255 individual arguments can be handled by the Sum Function, which can include cell references, numbers, ranges, arrays and constants.

### Excel SUM Formula

The SUM Formula accepts the following parameters and arguments:

**Number- **A numeric value which 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.

4.9 (1,353 ratings)

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

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.

### How to Open the SUM Function in Excel?

Below are the examples of 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 Excel 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 –

- VBA Excel Right Function with Examples
- How to Insert Date in Excel with examples?
- Concatenate Date in Excel
- Arrays in VBA Excel
- How to use the Excel Fill Handle from keywords?
- ROW Function in Excel
- RIGHT Function in Excel
- Search Function in Excel
- TEXT Function in Excel
- Concatenate Excel Function

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