How to sum up range that contains error?

June 15th, 2010 by admin admin

If you use the normal SUM formula, you will get #N/A. To find out the total of the values, you have to use the SUMIF formula¬†=SUMIF(B2:B10,”<>#N/A”), assuming that the range is from B2 to B10.

Leave a Reply

You must be logged in to post a comment.