2

I have inserted a running total formula in my numbers sheet. It sums the total of Column H, which works fine. However when cells in columns H are empty it will display the last sum, which I do not want.

How can I prevent displaying the last sum when Column A and B are empty?

enter image description here

enter image description here

|improve this question
4

You can extend the formula to check whether the value in the column to the left is empty or not:

=if(j3>0;sum(h$2:h3);"")
|improve this answer
  • Works like a charm thnks – user25765 Nov 15 '19 at 16:33

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .