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?