I am using a formula
=COUNT(IF(($N$2:$N$4000="NAX")*($M$2:$M$40009)*($ M$2:$M$4000<15),$M$2:$M$4000))
which tallies all entries in the range M2:M4000 that are NAX and between
10-14 value. Now I need to change NAX to be a wildcard so that it can count
NAA, NAE, NAX, NAH etc with a value between 10-14. I have tried
=COUNT(IF(($N$2:$N$4000="NA?")*($M$2:$M$40009)*($ M$2:$M$4000<15),$M$2:$M$4000)) but that doesn't work. Please help.