SUM

Syntax:

SUM ( argument-list )

Description: Adds the numeric values of arguments in argument-list.

Arguments:

Name

Type

Description

argument-list

logical, number, name, text, array, reference.

The arguments in argument-list designate the numeric values to be added. Arguments that are numbers, logical values, or text representations of numbers shall be counted. If an argument is an array or reference, only numbers in that array or reference shall be counted. Empty cells, logical values, and text in the array or reference shall be ignored.

Return Type and Value: number – The sum of the values of its arguments.

example: