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
0

1 Answer 1

Reset to default
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
1
  • Works like a charm thnks
    – user25765
    Nov 15, 2019 at 16:33

You must log in to answer this question.

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