CUMULATE

Cumulates a range of values, i.e. every number of the range is added to the sum of all previous numbers.

Syntax

CUMULATE(range; orientation)

• range - a range of values - Value type: range with numbers as expected values

• orientation - the orientation of the sum calculation - Value type: constant (optional, vertical as default). Possible values are:

  • vertical - the cumulated values are calculated column-wise

  • horizontal - the cumulated values are calculated row-wise

Remark

• Cells which cannot be converted to numbers are evaluated as 0 in the calculation of the cumulated values.

Examples

This example shows that letters and empty cells are evaluated as 0: