SUM

To add multiple numbers in Excel
Adds its number arguments

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:

Sum range of cells based on the rule in Excel

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.

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

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.

Read More »
Multiply the corresponding value and sum in Excel

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.

Read More »