Avoiding #n/a cells

  • Thread starter Thread starter Ferris
  • Start date Start date
F

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.
 
Hi Ferris

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

HTH
Frank
 
Back
Top