Clint Wagner wrote in news:4107E174.3000403
@indiana.edu:

merjet wrote:

I need help with a countif that will:
Count the number of times that: data in column A 2000 and the
text in
column B ="*best*"


=SUMPRODUCT((A:A2000)*(B:B="*best*"))

HTH,
Merjet


That's not helping. Im getting N/A everytime. Cant I use a
COUNTIF?

If you adjust Merjet's values of A:A and B:B to reflect your range
(A1:A500 and B1:B500) it will work.

Dave