How do I calculate cumulative readings?

3.44K viewsFormulas and Functions
0

Hi,

What a wonderful program!!!

However, i’m strugling with one or two formula. I am taking measurements over time and need to sum all the reading for the previous time points (kind of a cumulative calculation)- see example below

Time /Readings /Sum Previous readings
1 / 5 / 0
2 / 18 / 5 (Reading at time 1)
3 / 18 / 23 (sum of Readings at time 1&2)
4 / 20 / 41
5 / 32 / 61

Basically I need to sum the readings where the time is less that the current time point (if that makes sense)

Can you help?

0

Hi,

Thank you for writing. You can accomplish this by using the following formula:

Total:Time[THIS]= sum (Readings:Time[FIRST] .. Readings:Time[PREV])

Please see attached example model.

Kind regards,

Els