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:

SUM(1,2,3,4,5) results in 15
SUM({1,2;3,4}) results in 10
SUM({1,2,3,4,5},6,"7") results in 28
SUM({1,"2",TRUE,4}) results in 5, as the logical value and numeric text are ignored

end example]