Google Sheets: How to Filter with Multiple Conditions


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

Leave a Reply

Your email address will not be published.