=IF(ISERROR(SUM(A1:A100)),"",SUM(A1:A100))


"Curtis" wrote:

I am trying to add two cells and ach cell contains a formaula. I keep getting
the error #VALUE! when one of cells does not produce a value

Is there any way to avoid this

Thanks