How to Use COUNTIF Contains in Google Sheets


You can use the following formulas in Google Sheets to count the number of cells that contain certain strings:

Method 1: COUNTIF Contains (One Criteria)

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

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

Method 2: COUNTIF Contains (Multiple Criteria)

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

This formula counts the number of rows where the cell in the range A2:A11 contains “string1” and the cell in the range B2:B11 contains “string2.”

Note: The * operator is a wildcard character in Google Sheets.

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

Example 1: COUNTIF Contains (One Criteria)

We can use the following formula to count the number of cells in the Team column that contain the string “Mav”:

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

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

From the output we can see that 5 rows in the Team column contain “Mav” somewhere in their cell.

Example 2: COUNTIF Contains (Multiple Criteria)

We can use the following formula to count the number of rows where the Team column contains “Mav” and the Position column contains “Guar”:

=COUNTIFS(A2:A11, "*Mav*", B2:B11, "*Guar*")

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

From the output we can see that 2 rows contain “Mav” in the Team column and “Guar” in the Position column.

Additional Resources

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

Google Sheets: COUNTIF Greater Than Zero
Google Sheets: How to Use COUNTIF with OR
Google Sheets: How to Use COUNTIF From Another Sheet

Leave a Reply

Your email address will not be published. Required fields are marked *