SUM

Description

Returns the sum of the supplied numbers.

Syntax

SUM ( number_list )

Parameter	Description
number_list	A list of up to 30 comma-separated numbers or source fields: The list can contain numbers, logical values, or text representations of numbers. Source fields can contain only a single value. Error values or text that cannot be translated into numbers return errors. If there are no numbers in the list, 0 is returned.

Examples

This function returns 6000:

SUM(1000, 2000, 3000)

For the following example, assuming that S7 contains 34, S8 contains 227, and S9 contains 74, this function returns 335:

SUM(S7,S8,S9)