How to create a Cumulative Total formula from varied data

I'm trying to make a cumulative total formula for a dial guage i have set up to measure displacement. The gauge only goes up to 50 so it has to be reset when it approaches that value, and sometimes it doesn't work properly and is reset earlier, or just reported as not working. I would like the cumulative total to equal the cumulative total of the last reading if no reading data is added and the instrument to be reset multiple times. The formula is for the cumulative total column. The data I have set up in the sheet as follows:

Please Login or Register  to view this content.

Any help would be tremendously appreciated!

Hi Addict,

If not having E11 blank works for you then this seems to do the trick:

Please Login or Register  to view this content.

assuming your data starts in column A, with *** total in column E, try this formula in E3, copied down...

=IF(ISTEXT(B3),E2,IF(E2+B3>=50,0,B3+E2))

In E2, just use =B2

Hi Addict,

I tweaked it - hope it's what you want:

Please Login or Register  to view this content.

Hi Addict,

You're welcome.