Clint Wagner wrote in news:#Ti$JEMdEHA.2908
@TK2MSFTNGP10.phx.gbl:

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*"

Thanks,
Rog


If I understand your needs correctly as counting only the number of
intersect points between column A and column B this should work for
you.

Enter this as the formula
=SUM((A1:A252000)*(B1:B25="best"))
adjusting A25 and B25 to suit your needs then press
CTRL+SHIFT+ENTER simultaneously to establish it as an array
formula.

You will know you have correctly entered it as an array formula
when you see
{=SUM((A1:A252000)*(B1:B25="*best*"))}
in the edit bar. Excel adds to braces for you.

HTH
Dave