This works for me when my list of values begin in Cell A1.

Put this formula in Cell B1 and copy down:
=SUMPRODUCT(SUM(INDIRECT("$A$"&MAX(--($A$1:A1=0)*ROW($A$1:A1),1)&":"&CELL("address",A1) )))

Does that help?

--
Regards,
Ron


"Midnight404" wrote:

Can someone help? I want to keep a running total of one column but if it
encounters a zero in the column then I want the zero to reset the total to
zero and continue from that point. Help is appreciated.
--
neta