How to Sum values of a range by ignoring #N/A or other errors?

 If you are summing up a range of cells, which also contain #N/A’s in many cells. Then this would give you #N/A, in the formula cell. However, to resolve this problem you could use the sumif function instead of simple sum function. The syntax of the formula would be like this.

=SUMIF(D10:I10,” <>#N/A”)

Download Practice File: sumwithout#NA

Contact Us

Learn Excel Tricks