Unequal to a cell containing a formula

Copper Contributor

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 Replies



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


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


unequal to a cell containing a formula.JPG

Thank you so much, I will try it definitely