Hi merjet

AFAIK SUMPRODUCT does not work on entire columns - need something like.....

=SUMPRODUCT((A1:A1002000)*(B1:B100="*best*"))


--
XL2002
Regards

William



"merjet" wrote in message
...
| 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
|
|