Please enable JavaScript to view the comments powered by Disqus.


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


COUNTIF(range, criteria)

Lets chat on this