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