SUM

Returns the sum of a series of numbers and/or cells.

Sample Usage

SUM(-5,10)
SUM(C5,C6)
SUM(A1:C2)
SUM(A2:A)

Syntax

SUM(value1, [value2, ...])

• value1 - The first number or range to add.
• value2, .. - [OPTIONAL] Additional numbers or ranges to calculate for the sum.
  

Examples

• SUM(-5,10) returns a value of 5.
• SUM(C5,C6) returns the sum of the numbers contained in the two cells: C5 and C6.
• SUM(A1:C2) returns the sum of all the numbers contained in the range of cells. This function sums up the numbers in cells A1, A2, B1, B2, C1 and C2. 
• SUM(A2,A) returns the sum of all values in column A, starting at cell A2.

Notes

• If only a single number for value1 is supplied, SUM returns value1.