Avoiding #n/a cells

[Ferris]

I have a few lookup formulas in range K18:K173 that are returning #n/a
results. Those will disappear soon when data is entered in the data
source. I'm trying to run summary totals, but the formula
=SUMIF($K$18:K$173,B181,$J$18:$J$173) returns #n/a. How do I change
this so that it ignores #n/a values in the range? Thanks.

 

[Frank Kabel]

Hi Ferris

you should change your lookup formulas in K18:K173. e.g.
=IF(ISNA(lookup_formula),"",lookup_formula)

HTH
Frank