reset to zero
 

i need to keep a running total of a random series of numbers in a column
and when a zero appears i need it reset to zero and start counting again
from the next number, hope i explained this as easy as possible? thanks
for any help.


--
baldyheed
------------------------------------------------------------------------
baldyheed's Profile: http://www.excelforum.com/member.php...o&userid=27721
View this thread: http://www.excelforum.com/showthread...hreadid=472366

Hi!

Assume the numbers are in the range A1:An

Enter this formula in B1:

=(A10)*1

Enter this formula in B2 and copy down as needed:

=IF(A2=0,0,B1+1)

Biff

"baldyheed" wrote
in message ...

i need to keep a running total of a random series of numbers in a column
and when a zero appears i need it reset to zero and start counting again
from the next number, hope i explained this as easy as possible? thanks
for any help.


--
baldyheed
------------------------------------------------------------------------
baldyheed's Profile:
http://www.excelforum.com/member.php...o&userid=27721
View this thread: http://www.excelforum.com/showthread...hreadid=472366

Assuming that your numbers are in column A, in cell B1 put
=A1

in cell B2 put
=if(A2=0,0,B1+A2)

and formula-copy that to the end of your numbers.



baldyheed Wrote:
i need to keep a running total of a random series of numbers in a column
and when a zero appears i need it reset to zero and start counting again
from the next number, hope i explained this as easy as possible? thanks
for any help.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=472366

reset to zero and start counting again

I thought they wanted a count.

Well, either way we got it covered!

Biff

"Bryan Hessey"
wrote in message
news:Bryan.Hessey.1w95ic_1128218708.6221@excelforu m-nospam.com...

Assuming that your numbers are in column A, in cell B1 put
=A1

in cell B2 put
=if(A2=0,0,B1+A2)

and formula-copy that to the end of your numbers.



baldyheed Wrote:
i need to keep a running total of a random series of numbers in a column
and when a zero appears i need it reset to zero and start counting again
from the next number, hope i explained this as easy as possible? thanks
for any help.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=472366