SUM

See also A-Z Spreadsheet Function List

Description Returns the sum of the supplied numbers.

Syntax SUM(number_list)

number_list is a list of as many as 30 numbers, separated by commas.

The list can contain numbers, logical values, text representations of numbers, or a reference to a range containing those values.

Error values or text that cannot be translated into numbers return errors.

If a range reference is included in the list, text, logical expressions, and empty cells in the range are ignored.

See Also AVERAGE , COUNT , COUNTA , PRODUCT , and SUMSQ functions

Examples SUM(1000, 2000, 3000) returns 6000

         SUM(A10:D10) returns 4000 when each cell in the range contains 1000