**Rational**

To add multiple numbers

**Description**

The Excel SUM function returns a number after adding multiple numeric arguments together.

For example, suppose that a list of digits is in a column and user want to find the addition of figures, the formula can be **=SUM(5,10,15**) the Excel add numbers together and returns **30**.

**Syntax**

=SUM(number1,[number2],…)

**Parameters**

**number1** – The first number to add**number2 **[optional] – The second number to add. The SUM function can accommodate up to 255 numbers as an argument.

**Return Value**

The total sum of the given numbers

**Key Notes**

- The SUM function ignores text values within the reference while adding numbers. For example,
**=SUM(5,a,10,15)**will ignore text**“a”**and add only numeric numbers. - The Formula won’t update references if the user inserts rows or columns and does not return #REF! error from deleting rows or columns, unlike simple addition on the spreadsheet (using “+” operetor: 5+10+15).
- Arguments can be supplied by individual values, cell references, constant, multiple tables, array or ranges.

**Example(Image above)**

For example , user wish to add numbers in multiple array like here two columns (Expense A and Expense B) to add them together we put formula

=SUM(E5:E7,F5:E7) it return 877.

## Keep Reading Similar Functions:

### SUMIF

The SUMIF function returns a sum of number based on given criteria, like =SUMIF({2;8;10;3;5},”>5″) add numbers that are only more than 5 and returns 18.

### SUMPRODUCT

The SUMPRODUCT function returns a sum of the product of numbers together distributed in multiplies ranges or arrays, an easier way to add multiple integers.

### SUMIFS

The SUMIFS function returns an addition of numerical as per multiple criteria based on the match of dates, numbers, and text against the reference.