Forum Discussion

Tbarber's avatar
Tbarber
Copper Contributor
Nov 27, 2020

running total?

I am using an running total but having trouble to have the Total cell blank until data is entered for that line. This is all because I set the formula for the whole column. See the following example ...
excel
Tbarber's avatar
Tbarber
Copper Contributor
Nov 27, 2020

adversi 

 

That's great thanks, I guessed there would be a IF statement somewhere. Except in the fields where there is not input data yet it places a 0 in Total sum cell. Think there is a way just to have it blank?

 

Tom

adversi's avatar
adversi
Iron Contributor
Nov 27, 2020

Tbarber 

Yes, you can see that by default, when there is nothing in the TRUE statement in the IF statement, the value is 0. To edit this, a "" needs to be added in that section. The new formula will be:

=IF(B3="","",SUM($B$3:B3))

Resources