Hi,

I've got a complete mind block on how to get this right!

I have 5 values in cells a1:a5 - 1, 2, NULL, 4, and 5. When I try and sum
all 5 cells I get #value! Can I sum all five cells (12) even if there is a
NULL in a cell please?

Thanks in advance,

AW