I have amount as you can see in the picture, in row 2,
in row 3 I am doing accumulative amounts
in row 4 I would like to know a formula that produces the results that I had to doing manually, is there a way for this please?
So if someone has No blank cells in row 2, it keep adding up, but once there becomes a blank cell the adding starts from the first amount and continues.
Thank you so very much
Mac mini
Looks like the correct results all the way to row 10. Probable reasons why it did not work in row 11:
Looks like the correct results all the way to row 10. Probable reasons why it did not work in row 11:
Sorry forgot the picture
That's perfect thank you,,
But I want to change to a vertical table, I am messing it up somehow?
Thank you again for your help
B4 formula =B2
C4 formula =IF(C2="","",SUM(B4,C2))
Fill right from C4 to complete the row
Wow thank u. In the b11 I went in and there was indeed a space. Thank you so very much.
Running totals but restart amount if a blank cell between
