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.
Using COUNTIF to count for text contained in a string
Counting cells containing text
How to count if cell contains text
Counts the number of cells within a range that meet the given criteria
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM