numbers
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?
To add a new column right after the existing column:
Repeat for each existing column to create a new blank column on their right.
To create 20 new column at once:
This one will create 20 blank column right after the existing column. You need to rearrange them later.
You can do this using header and footer rows. These automatically adjust the formulas contained within them based on the number of rows above.
Make sure you have the footer row enabled:
In the footer cell, enter =SUM↩︎.
Select the column by clicking the relevant header cell or column reference.
The formula will automatically adjust from now on.
An animation for further explanation:
Best Answer
You can extend the formula to check whether the value in the column to the left is empty or not: