Count Text Occurrences

 

This example teaches you how to count the number of occurrences of text in a range.

1. For example, to count the number of cells that contain exactly star.

Countif Function in Excel, Exactly

2. For example, to count the number of cells that contain exactly star + 1 character. A question mark (?) matches exactly one character.

Countif Function, Question Mark

3. For example, to count the number of cells that contain exactly star + a series of zero or more characters. An asterisk (*) matches a series of zero or more characters.

Countif Function, Asterisk

4. For example, to count the number of cells that contain star in any way. No matter what is before or after star, this function finds all the cells that contain star in any way.

Count All Occurrences

5. For example, to count the number of cells that contain text.

Count Cells That Contain Text

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Count Text Occurrences    |    Go to Next Example: Count Logical Values