CUMULATIVE function

The Klipfolio CUMULATIVE function calculates a sequence of partial sums and returns the results as an array of values.

The syntax for the CUMULATIVE function is:

CUMULATIVE( data )

CUMULATIVE example

Let's look at a CUMULATIVE function example.

 

A

B

1 Apples 10
2 Oranges 12
3 Pears  
4 Peaches 15
5 Bananas 5

The following example is based on the above text from an Excel spreadsheet:

CUMULATIVE ( B:B )

-> [10, 22, 22, 37, 42 ]

Related links: