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
