SUM

  • Updated

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 A1A2, 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.