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

[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

 

[Don Guillett]

"no cigar" is not very descriptive. Post your formula and tell us what
happens.

 

[Jason Morin]

=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

 

[Paul Lautman]

Any clues as to why it fails to get the cigar, it'll help us to tell you how
to fix it.