COUNTIF(...)
Using COUNTIF to count for text contained in a string
Used Functions
Category: Statistical
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Practice COUNTIF Formula at Sheetzoom
COUNTIF formula at Microsoft help
0
The formula used wild card search feature by adding ampersand sign in the start and end of the search criteria and thus we have count of text appearing in a range.