*62*

You can use the following syntax to filter for cells that contain certain text in Google Sheets:

=FILTER(A1:C17, REGEXMATCH(A1:A17, "East"))

This formula filters the cells in the range A1:C17 to only return the rows where cells in the range A1:A17 contain the word “East”.

You can also use the following syntax to filter for cells that contain one of several values in Google Sheets:

=FILTER(A1:C17, REGEXMATCH(A1:A17, "East|West"))

This formula filters the cells in the range A1:C17 to only return the rows where cells in the range A1:A17 contain the word “East” or “West”.

The following examples show how to use this syntax in practice.

**Example 1: Filter for Cells that Contain Text**

Suppose we have the following data in Google Sheets:

We can use the following formula to filter for rows where the Region is equal to “East”.

Notice that only the rows where the Region is equal to “East” are returned.

**Example 2: Filter for Cells that Contain One of Multiple Texts**

Once again suppose we have the following data in Google Sheets:

We can use the following formula to filter for rows where the Region is equal to “East” *or* “West”:

Notice that only the rows where the Region is equal to “East” or “West” are returned.

**Additional Resources**

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

How to Sum Filtered Rows in Google Sheets

How to Filter Multiple Columns in Google Sheets

How to Use SUMIF with Multiple Columns in Google Sheets