Hi,

I wonder if anyone can help me with a seemingly straightforward, but
tricky, Excel "feature".

It appears that Excel treats differently a blank cell and a cell
containing a formula that returns blank. E.g., try the following
simple case:

A1: leave blank
B1: enter formula: =""
A2: enter formula: =A1+1
B2: enter formula: =B1+1

Result of A2 = 1
Result of B2 = #VALUE!

When trying to sum such cells, the blank cell is happily treated as a
zero, whereas the one with a formula in it causes an error.

(A bit more detail - I am pulling numbers from one sheet to another.
But when a number is missing on the first sheet I want a blank to be
inserted in the second, rather than a zero. But this messes up
formulae on the pulled through values)

Any ideas how to get round this?

Thanks,

Matthew