Say we want to sum C1 thru C12, but ignore any errors in that range:

=SUM(IF(ISERROR(C1:C12)=FALSE,C1:C12))

This is an array formula inserted with CNTRL-SHFT-ENTER rather than just ENTER
--
Gary''s Student - gsnu200755


"Jeffrey" wrote:

The range I need to sum can sometimes contain references to cells that have
been deleted, creating a formula that looks like =SUM(A1,C4,#REF!,D16:D22)
How can I get the formula to automatically disregard that specific error, and
return the sum of the other cells?