WHERE clause for filtering in Google Sheets - Step-by-Step Guide

Introduction

Filtering data helps you see only the rows you want based on conditions. In Google Sheets, you can use the FILTER function to show rows that meet specific criteria, similar to a WHERE clause in databases.

When you want to see only sales records from a specific region in your sheet.

When you need to list employees who joined after a certain date.

When you want to extract products with prices above a certain amount.

When you want to create a summary table showing only active customers.

When you want to filter survey responses that meet a particular answer.

Steps

Step 1: Click

- an empty cell where you want the filtered results to appear

The cell is selected and ready for input

Step 2: Type

- the formula bar

You start entering the FILTER formula

💡 Start with =FILTER(

Step 3: Enter

- the range of data you want to filter inside the formula

The formula now knows which data to check

💡 Example: A2:C20

Step 4: Type

- the condition for filtering after a comma in the formula

The formula filters rows that meet this condition

💡 Example: B2:B20="East" filters rows where column B is East

Step 5: Close

- the formula with a parenthesis and press Enter

The filtered data appears in the selected cell and below

Before vs After

Before

Sheet shows all sales data from all regions in rows 2 to 20

After

Sheet shows only rows where the region column says East, starting from the selected cell

Settings Reference

FILTER function

📍 Formula bar

To show only rows that meet the given condition(s)

Default: No default, must specify range and condition

Common Mistakes

Using FILTER without specifying the condition range correctly

The formula may return an error or wrong results if ranges do not match in size

Make sure the condition range matches the size of the data range exactly

Forgetting to close the FILTER formula with a parenthesis

The formula will not calculate and show an error

Always end the formula with a closing parenthesis )

Summary

FILTER function in Google Sheets works like a WHERE clause to show rows that meet conditions.

You must specify the data range and the condition range with the condition inside FILTER.

Make sure ranges match in size and close the formula properly to avoid errors.