Searching for a specific word in a table and counting the occurences.

  • Thread starter Thread starter DiamondMan
  • Start date Start date
D

DiamondMan

I need help on counting how many times specific word appears in
particular column or range of cells?
CountIf gets close but no cigar
 
"no cigar" is not very descriptive. Post your formula and tell us what
happens.
 
=COUNTIF(A:A,"*myword*")

will count "myword" in a cell as 1 occurrence, even if
it's buried within other text. However, if "myword" can
appear more than once in cell and each occurrence in the
cell needs to be counted, then use:

=SUMPRODUCT((LEN(A1:A10)-LEN(SUBSTITUTE
(A1:A10,"myword","")))/LEN("myword"))

HTH
Jason
Atlanta, GA
 
Any clues as to why it fails to get the cigar, it'll help us to tell you how
to fix it.
 
You must log in or register to reply here.

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

count the dates for each criteria and list total occurances for ea 1
Counting occurences with multiple entries 5
Counting items with a specific quanitifier in a date range 3
count text occurance in range 3
counting the occurrence of specific text within a date range 4
Need to Count the number of times a value occurs within a dt range 9
Multiple arguments 1
Excel Need Countifs Formula Help 0

Back
Top