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

  • Thread starter Thread starter Chris Eaton
  • Start date Start date
C

Chris Eaton

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))
 
Back
Top