Forum Discussion
Unequal to a cell containing a formula
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
=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.
- Thank you so much, I will try it definitely
