MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Summing and #N/A


Posted by Jeff Geller on June 19, 2001 8:26 AM

Pretty basic question. How can I sum a list of results that will have some #N/As in it and have the value of the #N/A equal 0. When I sum, the result is #N/A instead of the sum of the valid results.


Posted by Aladin Akyurek on June 19, 2001 8:33 AM

Try:

=SUMIF(A1:A10,"<>#N/A",A1:A10)

Aladin