Raeding blank cells as zero values

[ofeyrpf]

Hi,

I have two cells which I want to add. But one or both cells may be blank. I want the value of any blank cell to be read as zero.

I have attached a simplified attempt to get this to work using =IF(OR(A1="",B1=""),0,A1+B1) but this gives a zero value for the sum if either of the cells being summed is zero.

Any ideas,

Thanks,

Shane

[jeffreybrown]

Hi Shane,

Maybe I'm missing it, but why not just =SUM(A2:B2) if you want C2 to equal 1,800.00

[martindwilson]

what's wrong with =SUM(A1:B1)?

[ofeyrpf]

That's weird the formulas are working now, before I was getting a #value error when a formula used a blank cell.

Oh well problem solved.

Thanks,

Shane

[martindwilson]

you'd get a value error if you use =a1+b1 and one of the cells is text or a space and even if its "" as the result of a formula sum() ignores text