Please enable JavaScript to view the comments powered by Disqus.


COUNTIF(...B4:B13,"*"&"Cripps"&"*")

Using COUNTIF to count for text contained in a string

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. 


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