Hi,

I cannot make a cell with zero in it add to another cell with a figure and
get an answer?
i.e.

A3 = A1+A2

16 = 0 +16 My formula is 'A1+A2'

I have results in my formula's where A1 or A2 will be populated by a 0, an
empty space, or in fact a number. I then need A3 to be the sum of A1+A2 but I
cannot get my formula to add, instead I get #VALUE?

So the math could even become 0+0=0 <-- but this is less likely.

Can anyone help?

Thanks in advance Scott