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.

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

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.

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.

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

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

0 comments:

Post a Comment

 
Top