Blank cell creates #value and will not add column total

[Flipchick]

I looked and did not see this specific issue. I am using nested formulas to fill a cell or have it be blank. I would rather not see "0" or true false in the cell. I have accomplished that for individual columns. However, when I want to have a running balance, the balance column will not add as a row or a column. I have attached a spreadheet. I am using "" to return a blank cell. TYIA

 

[jasonb75]

You can not use operators such as + - * or / with a cell that contains anything which is not numeric. You will need to use alternatives such as the SUM function.

=SUM(F4,C5,D5,E5) or =SUM(F4,C5:E5)

 

[Joe4]

Welcome to the Board!

Another option would be to return 0 instead of "".
Then, just apply a Custom Format to your range to hide the zeroes, so you won't see them.
See: Display or hide zero values

 

[Flipchick]

You can not use operators such as + - * or / with a cell that contains anything which is not numeric. You will need to use alternatives such as the SUM function.

=SUM(F4,C5,D5,E5) or =SUM(F4,C5:E5)

That did not seem to work

 

[Flipchick]

Welcome to the Board!

Another option would be to return 0 instead of "".
Then, just apply a Custom Format to your range to hide the zeroes, so you won't see them.
See: Display or hide zero values

Thank you, that seemed to do the trick. I appreciate it.

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[jasonb75]

That did not seem to work

Both should work fine if used correctly. The suggestions were based on your formula of =F4+C5+D5+E5