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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL COUNTING HELP 3
Count cells with a date falling within a 30 day period. 2
counting the number of events in a year 2
Count Consecutive Numbers in a Row 4
counting groups of words 4
counting the number of times a word appears 5
counting entries 4
Sum Count of Numeric Criterion for LAST 5 Rows 5

Back
Top