Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to filter by multiple conditions in Google Sheets.
How To Filter By Multiple Conditions in Google Sheets
The FILTER function in Google Sheets is an excellent way to filter your data. The function allows you to set multiple conditions, and only return the results that match all of those conditions.
For example, let’s say you have a list of phone numbers and email addresses. We can use the FILTER function return a list of entries with phone numbers starting with ‘5’ and email addresses that end with ‘@gmail.com’
In this guide, we will show you how to filter by multiple conditions in Google Sheets using the FILTER function. We will also explain how to handle multiple conditional statements that refer to the same column in the selected range.
How To Filter a Range Using Two or More Conditions in Google Sheets
Here’s how to filter a range using two or more conditions in Google Sheets.
Select an empty cell in your spreadsheet. Type the string ‘=FILTER(‘ to start the FILTER function.
Next, type the cell range you want to filter with multiple conditions as the first argument.
Starting with the second argument, add conditional statements to filter the selected range.
In the example above, we’ll filter the range to only show orders with a country code equal to “CN” and have a quantity greater than 10.
Just hit the Enter key to evaluate the FILTER function.
If you want to add OR logic on conditions based on the same column, we can use the ‘+’ symbol between conditional statements.
We could also convert the statement to AND logic by using the ‘*’ symbol instead.
You should now have an output that filters the selected data using multiple conditions.
This guide should be everything you need to filter by multiple conditions in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.