Since I assume your error comes from a cell I replaced it with E4 but if you
put #REF! in E4 you will see that this works

=SUM(SUMIF(INDIRECT({"A1","C4","E4","D16:D22"}),"< =0"&999^99))



--


Regards,


Peo Sjoblom


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