SUM

Returns the sum of the specified arguments.

Syntax

SUM( Number n1, [Number n2], ... ) → Number

Parameters

n1
n2
…

One or more numbers to sum.

Remarks

The arguments can be either numbers or cells, ranges, or arrays that contain numbers. Logical values, text, and empty cells are ignored. If the specified arguments do not contain any numbers, the function returns 0.

Example

Formula

=SUM(A1:A5,10,{1;4})

See Also

Function Reference
AVERAGE Function
COUNT Function
COUNTA Function