Hi
better to use sUMPRODUCT. Try (non-array entered):
=SUMPRODUCT(--(LEFT($N$2:$N$4000,2)="NA"),--($M$2:$M$40009),--($M$2:$M$4000<""))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

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.