Skip to Content

Google Sheets Filter By Multiple Conditions (Easy Steps)

Posted on Last updated:

Welcome to the world of Google Sheets, where you can filter by multiple conditions. In this beginner-friendly guide, we’ll demystify the art of filtering by multiple conditions, breaking it down into simple steps.

Whether you’re managing a project, analyzing sales figures, or tracking expenses, this technique will help you cut through the data clutter like a pro.

Scenario/Use Case

Let’s dive into a real-world scenario to illustrate the power of filtering by multiple conditions. Imagine you’re an e-commerce store owner, knee-deep in a massive spreadsheet containing your product inventory. Each row is a unique product, and you need to identify which items meet specific criteria to effectively plan your next marketing campaign.

Here’s where filtering by multiple conditions comes to your rescue. You want to find products that meet the following criteria:

  • The product is in the “Electronics” category.
  • The product price is below $200.
  • The stock availability is greater than 10 units.

Without the ability to filter by multiple conditions, this task could be incredibly time-consuming and error-prone. But fear not. This feature acts as your data detective, allowing you to zoom in on precisely the products that meet all these criteria simultaneously.

Now, you can create a targeted marketing strategy for affordable electronics with ample stock, saving you time and helping you make data-driven decisions.

Let’s embark on this journey so you finally get the hang of how to filter by multiple conditions in Google Sheets. 

How To Filter By Multiple Conditions

Now that we’ve discussed what it means to filter by multiple conditions in Google Sheets and shared a practical scenario to illustrate its usefulness, let’s break down the process step by step. 

We’ll guide you through how to filter your data in Google Sheets using multiple conditions, making it easy to understand and apply.

We will use the following sample data to demonstrate how to filter by multiple conditions in Google Sheets. 

With our sample data nicely put together, let’s show you the step-by-step process of filtering data in Google Sheets by multiple conditions. 

Step 1: Select An Empty Cell In Your Spreadsheets

Let’s start by picking a cell in our spreadsheet where we want Google Sheets to show us the filtered results based on multiple conditions. In simpler terms, this is where we’ll see the information we’re looking for.

For this example, we’ll choose a cell called H1. So, go ahead and click on or select H1 in your spreadsheet.

Step 2: Type in the Filter Function

Now that we have selected a cell where we want the result of filtering by multiple conditions generated, let’s quickly input our filter formula. To do that, head to the formula bar and type in the following formula. 

=FILTER(A2:E13, (C2:C13 = “Electronics”) * (D2:D13 < 200) * (E2:E13 > 10))

Let’s break down the formula for you:

  • FILTER: This function is used to filter data based on specified criteria.
  • A2:E13: This is the range of data you want to filter, which includes all the rows and columns of your sample data.
  • (C2:C13 = “Electronics”): This part checks if the Category (Column C) equals “Electronics.”
  • (D2:D13 < 200): This part checks if the Price (Column D) is less than 200.
  • (E2:E13 > 10): This part checks if the Stock Availability (Column E) is greater than 10.
  • The * operator between conditions acts as an “AND” operator. It means that all three conditions must be true for a row to be included in the filtered results.

Step 3: Hit Enter

Now that we’ve entered the filter formula, as explained in the previous step, here’s what you need to do next: simply press the “Enter” key on your keyboard. This is like giving Google Sheets the green light to show you the filtered results based on the multiple conditions set in the filter formula.

Here’s a glimpse of what your spreadsheet will display after you press “Enter”:

Take a look at the picture above. You can see that we used the filter formula we talked about earlier, and it worked. By deploying the filter formula, we were able to filter our spreadsheet based on multiple conditions.

Final Thoughts

To wrap up, using Google Sheets to filter your data based on multiple conditions can be a real game-changer.

We started by explaining how working with data in Google Sheets can sometimes feel like solving a complex puzzle, but by leveraging filter by multiple conditions, you can make your job a lot easier. 

We even used a practical scenario where you, as an e-commerce store owner, needed to identify specific products in your inventory to plan a marketing campaign effectively.

We then walked you through the step-by-step process:

  • Step 1: Select an empty cell: We began by choosing a cell in our spreadsheet where the filtered results will appear. This is where you’ll see the data that meets your criteria. For our example, we picked cell H1.
  • Step 2: Type in the filter formula: In this step, we introduced the formula you need to use, which is 

=FILTER(A2:E13, (C2:C13 = “Electronics”) * (D2:D13 < 200) * (E2:E13 > 10))

This formula filters our data based on specific conditions, such as category, price, and stock availability. We explained each part of the formula in plain language.

  • Step 3: Hit Enter: Lastly, we showed you that after typing in the formula, you only need to press the “Enter” key on your keyboard. This action tells Google Sheets to generate the filtered results in your selected cell. You can see your filtered data right there in your spreadsheet.

Ultimately, using Google Sheets to filter by multiple conditions doesn’t have to be complicated. It’s a powerful tool that simplifies the process of finding specific information in your spreadsheets, and in today’s guide, we demonstrated how it works. 

Other Related Google Sheets Tutorials