Excel Functions Tutorials

- Excel Formulas Cheatsheet
- Excel
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- TRANSPOSE Excel Function
- Row Function in Excel
- OFFSET Excel Function

- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- DSUM
- COMBIN Excel Function
- INT Excel Function (Integer)

- Date and Time Function in Excel
- Statistical Function in Excel
- AVERAGE Excel Function
- CORREL Excel Function
- COUNT Excel Function
- COUNTIF Excel Function
- FREQUENCY Excel Function
- MAX Excel Function
- MEDIAN Excel Function
- GROWTH Excel Function
- SLOPE Function in Excel
- TREND Function in Excel
- SMALL Function in Excel
- MODE Excel Function
- LARGE Excel Function
- PERCENTILE Excel Function
- LINEST Excel Function
- T-TEST in Excel
- QUARTILE Excel Function

- Information Functions in Excel
- Excel Charts
- Excel Tools
- Excel Tips

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

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

## 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 Excel 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 on Excel 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 in excel, which can include cell references, numbers, ranges, arrays and constants.

### Excel SUM Formula

The SUM Formula in Excel 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.

### SUM in Excel – Constraints

The SUM function in excel has following constraints while using –

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

### SUM Function in Excel – Usage Notes

- The Sum Function in excel sums all the values which are supplied as arguments and up to 255 arguments.
- These arguments supplied in the Excel 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.

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?

- You can simply enter the desired Excel SUM formula in the required cell to attain a return value on the argument.
- You can manually open the Excel SUM formula dialogue box in the spreadsheet and enter the values to attain a return value.
- To open the Excel 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 in excel option. See the screenshot below.

- Once you click the SUM in excel option, the SUM in excel 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 in excel 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 a 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.

Based on the above Excel spreadsheet, let’s consider five Excel Sum Function Example and see the Excel SUM function return based on the Excel SUM formula.

### SUM in Excel Example #1

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

**Result: **

Consider the excel spreadsheet below.

### SUM in Excel Example #2

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

**Result:**

You can see the excel spreadsheet below.

### SUM in Excel Example #3

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

**Result:**

Consider the excel spreadsheet below.

### SUM in Excel Example #4

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

**Result:**

You can see the excel spreadsheet below.

### SUM in Excel 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 About the SUM Function in Excel**

- #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 in Excel 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.

You can download this SUM Function in Excel template here – SUM Function Excel Template

### 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 –

## Leave a Reply