MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum a series that has #N/A in it


Posted by Marion on January 23, 2002 6:28 AM

How do I have a sum of a series of cells, if the answer in
some of the cells is #n/a?

I have used conditional formatting to get the #n/a not to appear.
But I don't know how to get it to be excluded from the sum of the series...

Thanks


Posted by Mark W. on January 23, 2002 6:52 AM

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

Posted by Marion on January 23, 2002 6:56 AM

Mark - thanks so very very much!

I had a feeling I needed to use SUMIF, but I wasn't sure how.