Simple formula to count the occurrence of any text value in a cell or range of cells in Excel.
You will learn:
This simple tutorial combines the COUNTIF() function with wildcard characters.
=COUNTIF(A1:A5,"*red*")
red is the sample word to look for.
* asterisk is placed before and after the word and it means to match any character. You can place one of these before the text, one after the text, or one asterisk before and after the text.
CountIf Function in Excel (microsoft resource)
Count Words in Cells in Excel (older resource) (microsoft resource)