#VALUE!

C

Curtis

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
 
C

Curtis

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
 
C

Curtis

Sorry your formual works. I just needed to sum the two cells as

=IF(ISERROR(SUM(J1,AK1)),"",SUM(J1,AK1))
 
Top