SUM
Returns the sum of numers in a range.
Syntax
SUM(range; orientation)
range - a range of values - Value type: range
orientation - the orientation of the sum calculation - Value type: constant (optional, all as default). Possible values are:
all - the sum of the whole range is returned as a single number
horizontal - the sum calculation is performed horizontally (row-wise) and returned as a column of numbers
vertical - the sum calculation is performed vertically (column-wise) and returned as a row of numbers
Remarks
Empty cells or cells which cannot be converted to numbers are ignored in the sum calculation.
