Did you try? Chip's formula works for me with DIV0, VALUE and NUM errors.
So does this more long-winded one =SUM(IF(ISERROR(A1:A10),0,A1:A10))
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Rick Rothstein (MVP -
VB)" wrote in
message ...
To SUM a range and ignore errors, use the following array formula
=SUM(IF(ISNUMBER(A1:A10),A1:A10))
This will return the SUM of A1:A10, ignoring error values.
Not entirely true... put =0/0 or =SQRT(-1) in one of the cells within the
range.
Rick