SUMMATION()

SUMMATION()

Top  Previous  Next

 

The SUMMATION() function returns the total value of all elements of a numeric array.

 

 

Format

 

SUMMATION(expr)

 

where

 

exprevaluates to a numeric array.

 

 

The SUMMATION() function adds together all elements of expr, returning the total value. It is equivalent to repeated use of the SUM() function until just one value remains.

 

Non-numeric elements of expr are ignored.

 

 

 

Example

 

TOTAL.PAID = SUMMATION(PAYMENTS)

 

This statement sums a multivalued list of payments to form the total amount paid.

 

 

See also:

SUM()