Please enable JavaScript to view the comments powered by Disqus.


COUNTIF(...A3:A12,"*"&"Cripps"&"*")

Counting cells if cells contains certain text

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.


Used Functions

Category: Statistical

Counts the number of cells within a range that meet the given criteria

Syntax

COUNTIF(range, criteria)

Lets chat on this