Counting Cells that Match Content Criteria

[Agent86]

I'm trying to come up with a formula that allows me to count the number of cells in a range that contain a specific word in a string of text.

For example, I may want to count the number of cells that contain the term "LTC", and in the range of cells there may be an entry like, "New LTC form submitted by John Doe."

Any suggestions are most appreciated.

 

[azumi]

Assumed your data in A1:A5 :

=COUNTIF(A1:A5,"*"&"LTC"&"*")

 

[Agent86]

Awesome! I never thought of using wildcards! This is perfect ... thank you so much!