Need help with cumulative results

4

Hi!

If I understood this correctly, you want to restart counting whenever N1 is equal to 0?
If that’s the case, you should look into reference the cell above.
The formula should look something like this:

if(N1=0, N2, PreviousRow.Results+N2)

Hope that helps.
If not, would you mind sharing the doc? This way I could better understand what you are trying to achieve.

1 Like