SUM

Adds all the numbers in a range of cells.

Syntax

SUM(number1, [number2], ...)

Arguments

• number1, number2, ...: Numbers, cell references, or ranges to sum.

Example

SUM(10, 20, 30) → Returns 60
SUM(A1:A10) → Adds all numbers in the range A1:A10