Or maybe even
=SUMIF(A1:B1,"<#N/A")
of course the cells have to be adjoining
Regards,
Peo Sjoblom
"bj" wrote:
try
=if(iserror(A1),0,A1)+if(iserror(B1),0,B1)
"carl" wrote:
Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
#N/A ?
Thank you in advance
|