Thread: How do i count the number of text Entries of one word over a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default 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
Reply With QuoteReply With Quote