You can use the following methods in Google Sheets to filter data with multiple conditions:

**Method 1: Filter for Rows that Meet Multiple Conditions**

**=FILTER(A1:C10, A1:A10="A", C1:C10<20)**

This filter returns the rows in the range A1:C10 where the value in column A is equal to “A” **and** the value in column C is less than 20.

**Method 2: Filter for Rows that Meet One of Multiple Conditions**

=FILTER(A1:C10, (A1:A10="A")+(C1:C10<20))

This filter returns the rows in the range A1:C10 where the value in column A is equal to “A” **or **the value in column C is less than 20.

The following example shows how to use each method in practice with the following dataset in Google Sheets:

**Example 1: Filter for Rows that Meet Multiple Conditions**

We can use the following formula to filter for all rows where the team is equal to “A” **and** the points is less than 20:

**=FILTER(A1:C10, A1:A10="A", C1:C10<20)**

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

The only rows returned are the ones where the team is equal to “A” **and** the points is less than 20.

**Example 2: Filter for Rows that Meet One of Multiple Conditions**

We can use the following formula to filter for all rows where the team is equal to “A” **or **the points is less than 20:

=FILTER(A1:C10, (A1:A10="A")+(C1:C10<20))

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

The only rows returned are the ones where the team is equal to “A” **or** the points is less than 20.

**Additional Resources**

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

Google Sheets: How to Filter for Cells that Contain Text

Google Sheets: How to Use SUMIF with Multiple Columns

Google Sheets: How to Sum Across Multiple Sheets