Hi,

If you would like to sum up a range which has an error value, you can use
the following formula

-sumif(range,"0")+sumif(range,"<0")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ArcticWolf" wrote in message
...
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