Wildcards are helpful in searching for data throughout Excel and other database search tools. In my following example I have a list in which I want to count how many times Cincinnati appears in the list. The problem is that I have one entry as “Cincy” and the others as “Cincinnati”. The wildcard I will use is an asterisk. “Cin*” will find all cells that begin with “Cin”.
Using data validation I could have prevented entries to a clean list. Stay tuned next time for a post on data validation.
The COUNTIF formula needs a range. This is simply the cells in which I want to do the counting from. The second part to the COUNTIF is the criteria. I use “Cin*” which the * represents zero or more characters. “Cin*” would find “Cincy” and “Cincinnati”. So my formula now correctly reads 4. If I had tried to count “Cincinnati” then the formula would of skipped over “Cincy” and would have given me 3.