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
B4 formula =B2
C4 formula =IF(C2="","",SUM(B4,C2))
Fill right from C4 to complete the row
B4 formula =B2
C4 formula =IF(C2="","",SUM(B4,C2))
Fill right from C4 to complete the row
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
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
