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: