How do I sum values that may contain "#N/A" in Excel?

P

Peo Sjoblom

=SUMIF(Range,"<>#N/A")

or remove the cause that give the #N/A result

=IF(ISNA(A2),"",A2)
 
B

Bernard Liengme

=SUM(IF(ISNA(D1:D5),0,D1:D5))
enter as an array formulas - use SHIFT+CTRL+ENTER
 
Top