To add multiple numbers in Excel
Adds its number arguments


To add multiple numbers


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.




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:

Sum range of cells based on the rule in Excel


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.

Read More »
Multiply the corresponding value and sum in Excel


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.

Read More »
Sum range of cells based on multiple criteria in Excel


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

Read More »