How do i count the number of text Entries of one word over a range
 

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

How do i count the number of text Entries of one word over a range
 

=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

How do i count the number of text Entries of one word over a range
 

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