COUNTIF(...)
Counting cells if cells contains certain text
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 option by adding asterisk symbol in the start and the end of the text to be searched for in the range. The result gives us the final count.