To explain here is an example of the columns i have:

THC will not Span 
Nox will not Span 
THC fails AVU
THC will not Span

I would like to be able to count how many times the phrase "THC" is 
mentioned over the course of hundreds of data entry columns?

With this example i would look to have the answer of 3.

Please can anyone help.

Thanks

=COUNTIF(A:A,"*THC*")

-- 
Regards!
Stefi



„Chris Eaton” ezt írta:

> To explain here is an example of the columns i have:
> 
> THC will not Span 
> Nox will not Span 
> THC fails AVU
> THC will not Span
> 
> I would like to be able to count how many times the phrase "THC" is 
> mentioned over the course of hundreds of data entry columns?
> 
> With this example i would look to have the answer of 3.
> 
> Please can anyone help.
> 
> Thanks

If you are looking for exact match THC (in caps) then try the below formula. 
Apply the formula using Ctrl+Shift+Enter instead of Enter

=COUNT(FIND("THC ",A1:A100))

-- 
Jacob


"Chris Eaton" wrote:

> To explain here is an example of the columns i have:
> 
> THC will not Span 
> Nox will not Span 
> THC fails AVU
> THC will not Span
> 
> I would like to be able to count how many times the phrase "THC" is 
> mentioned over the course of hundreds of data entry columns?
> 
> With this example i would look to have the answer of 3.
> 
> Please can anyone help.
> 
> Thanks