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

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

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

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

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


--

Regards,

Peo Sjoblom

"bakerbabe" wrote in message
...

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

=SUM(IF(ISNA(D1:D5),0,D1:D5))
enter as an array formulas - use SHIFT+CTRL+ENTER
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bakerbabe" wrote in message
...