CUMULATE
Cumulates a range of values, i.e. every number of the range is added to the sum of all previous numbers.
Cumulates a range of values, i.e. every number of the range is added to the sum of all previous numbers.
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
Cells which cannot be converted to numbers are evaluated as 0 in the calculation of the cumulated values.
This example shows that letters and empty cells are evaluated as 0:
