This will generate a running total in column B, restarting after a blank
cell in Col. A

(your data should begin in row 2 with row blank)
Enter this in B2 and copy down the range of your data in A:

=IF(A1="",A2,IF(A2="","",B1+A2))

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=376203