5.3 C
London
Thursday, December 19, 2024
HomeSoftware TutorialsGoogle SheetsHow to Use COUNTIF with Wildcards in Google Sheets

How to Use COUNTIF with Wildcards in Google Sheets

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

You can use the following formulas in Google Sheets to use wildcard characters with the COUNTIF function:

Formula 1: COUNTIF with One Wildcard

=COUNTIF(A2:A11, "*string*")

This particular formula counts the number of cells in the range A2:A11 that contain “string” anywhere in the cell.

Formula 2: COUNTIF with Multiple Wildcards

=COUNTIFS(A2:A11, "*string1*", B2:B11, "*string2*")

This particular formula counts the number of cells where A2:A11 contains “string1” and where B2:B11 contains “string2.”

The following examples show how to use each formula in practice.

Example 1: COUNTIF with One Wildcard

We can use the following formula to count the number of cells in column A that contain “avs” anywhere in the cell:

=COUNTIF(A2:A11, "*avs*")

The following screenshot shows how to use this formula in practice:

From the output we can see that there are 5 cells in column A that contain “avs” in the name.

Example 2: COUNTIF with Multiple Wildcards

We can use the following formula to count the number of rows where A2:A11 contains “avs” and where B2:B11 contains “Gua”:

=COUNTIFS(A2:A11, "*avs*", B2:B11, "*Gua*")

The following screenshot shows how to use this formula in practice:

From the output we can see that there are 2 rows where the team contains “avs” and the position contains “Gua” somewhere in the cell.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

How to Use COUNTIF with OR in Google Sheets
How to Use COUNTIF From Another Sheet in Google Sheets
How to Use COUNTIFS with a Date Range in Google Sheets

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories