#VALUE!
The two cells in question that I need to add are J1 and AK1. This formula
does not produce the correct answer
ANy thoughts?
Thanks
"Teethless mama" wrote:
=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
|