), asterisk(*), or tilde (~).
A question mark (?)
matches any one character and an asterisk (*) matches zero or more characters of any kind.
The tilde (~) is an escape character to matchliteralwildcards that may appear in data.
In this example, we mainly use an asterisk (*).
Notice that COUNTIF isnotcase-sensitive.
and asterisk (*) wildcards.
Notice the hyphen (-) is hardcoded to make the pattern even more specific.
COUNTIF can be used to count…
