I have a small spreadsheet that shows this problem and if I can figure out how to attach it or upload it I will.
The problem I’m seeing is this:
I have a formula that generates either a blank or a number. The result of this formula is added to another number. If the formula generates a blank the result of cell+cell is #value, but the result of sum(cell:cell) is correct.
Looks like I can’t upload an example SS so here goes a long and tedious explanation.
Please enter the following and you will see the problem:
Cell A1 1
Cell A3 1
Cell A4 blank (i.e. nothing in this cell)
Cell A5 3
Cell A6 =A3+A4+A5
Cell B3 1
Cell B4 =if(A1=1,"",2)
Cell B5 3
Cell B6 =B3+B4+B5
Cell C3 1
Cell C4 =if(A1=1,"",2)
Cell C5 3
Cell C6 =sum(C3:C5)
If you get the same result I got then you will see the following:
This looks like a bug to me. Somehow when the formula evaluates to “”, addition fails, though a simple, non-formulaic “” works fine.
I’m hoping someone will either verify the problem and I’ll report a bug, or explain to me what I’m doing wrong.