You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Running totals but restart amount if a blank cell between

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

Posted on Sep 4, 2023 7:04 PM

Reply
Question marked as Top-ranking reply

Posted on Sep 5, 2023 9:42 AM

Looks like the correct results all the way to row 10. Probable reasons why it did not work in row 11:

  1. You have a space or tab or other invisible character in cell B11 (i.e. ,it is not blank or a null string) or
  2. The formula is not the same as in the upper rows

Similar questions

5 replies

Running totals but restart amount if a blank cell between

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.