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