Replied to Google Sheets COUNTIF Function (benlcollins.com)

COUNTIF Google Sheets supports three wildcards, *, ?, and ~.

The star * matches zero or more characters.

The question mark ? matches exactly one character.

The tilde ~ is an escape character that lets you search for a * or ?, instead of using them as wildcards.

Ben, I really need to do some work on picking the right tool for the task, so often I just use the QUERY formula to adjust my criterion out of habit. Using a COUNTIF seems a lot cleaner.

The post 💬 Google Sheets COUNTIF Function first appeared on Read Write Collect.