FILTER in Google Sheets: How to Use FILTER Function with Examples & Syntax Guide

Learn how to use the FILTER function in Google Sheets to extract data fast. Explore syntax, examples, and practical use cases for easy filtering.

You can use Google Sheets to store data and see it in real time. One of the best tools for looking at data in Google Sheets is the FILTER function. It lets you get only the information you need based on certain conditions, so you don't have to sort or delete anything yourself.

What Is the FILTER Function in Google Sheets?

The FILTER function in Google Sheets only shows the rows or columns that meet a certain condition. It filters your data automatically based on rules you define.

• Show only sales above a certain amount
• Extract only 'Completed' tasks
• Display data from a specific region
• Filter records by date

FILTER Function Syntax

• range → The data you want to filter
• condition1 → First rule that must be true
• condition2 (optional) → Additional rules

Basic Example of FILTER

If you have a dataset with Status in column B and want only 'Completed' tasks:

FILTER with Multiple Conditions

You can refine your results by adding more rules. For example, to show 'Completed' tasks with sales greater than 400:

Combining FILTER with Other Functions

• FILTER + SORT: =SORT(FILTER(A2:C10, C2:C10>300), 3, FALSE)
• FILTER + SUM: =SUM(FILTER(C2:C10, B2:B10="Completed"))

FILTER is one of the best tools for people who work with data all the time. It saves time, makes things more accurate, and lets you create smarter and more responsive spreadsheets.