# SUM

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