SUM

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.