Unequal to a cell containing a formula

[Carina_Bam]

Good day,

I am trying to count the number of fields unequal to #N/A by using the following formula =COUNTIF('CAT C'!'CAT C'!$D$2:$J$489,"<>$'#N/A")

Will it count it the field if there is formulas in?

[#2]

@Carina_Bam 

=SUM(IF(NOT(ISNA(D7:D17)),1))

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

=VLOOKUP(C7,$E$2:$F$4,2,FALSE)

This is the formula in cell D7. The formula is filled down to D17.

[#3]

Thank you so much, I will try it definitely