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

Advertisement

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

Advertisement

Do you like this free website? Please follow us on Google+