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.