First of all, no need for your ctrl + shift & enter formula, yopu might as
well use

=SUMPRODUCT(--(N2:N4000="NAX"),--(M2:M40009),--(M2:M4000<15))

instead of the count formula, to get the equivalent of the wild card you
can use

=SUMPRODUCT(--(LEFT(TRIM(N2:N4000),2)="NA"),--(M2:M40009),--(M2:M4000<15))

Regards,

Peo Sjoblom

"Rita" wrote:

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.