Adds together all the values in a list.
Syntax:
SUM(list)
Returns the sum of all the values in the list, which may be an array, a range of cells, or a comma-separated list of values.
Example:
SUM(B1:B14)
returns the sum of the values of cells B1
to B14
.