Adds (sums) the given expressions. If an expression evaluates to a range of cells all the values in the range are summed. Text cells in ranges are ignored. If an error condition is encountered in a range of cells, the sum function errors as well.
Syntax
SUM(expression,{expression},...)
Arguments
expression - numbers or references to sum.
Example
SUM(3.14,-2,2) is 3.14