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.

Examples