SUM

Description Returns the sum of the supplied numbers.

Syntax SUM ( number_list )

Argument Description

number_list A list of as many as 30 numbers. The list can contain numbers, logical values, text representations of numbers, range references, or array constants. 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.

Argument	Description
number_list	A list of as many as 30 numbers. The list can contain numbers, logical values, text representations of numbers, range references, or array constants. 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.

Examples This function returns 6000:

SUM(1000, 2000, 3000)

This function returns 4000 when each cell in the range contains 1000:

SUM(A10:D10)

See Also AVERAGE, COUNT, COUNTA, PRODUCT, SUMSQ