POWER OF COUNTIF FORMULA WITH WILDCARD CHARACTERS

Hi Folks,

In this posting we shall discuss how to use the wildcard characters “?“and “*“ in the COUNTIF formula to get some great results.

To understand this better, I have presented an example below

First formula will help us to get the count of the text entries alone

Second formula will help us to get the count of numerical values alone

Final formula will help us to get the count of those text entries whose length is 3 characters

If you use the COUNTIF formula with wildcard characters taking a formula column as a source range, then this behaves in completely different manner.

1st formula counts everything including the null entries returned by the formula.

2nd formula will count every entry excluding the null entries returned by the formula.

Hope you got some new ideas how to use the wildcard characters with COUNTIF formula.

Happy Learning!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.