Google Sheets / 6 min read
Google Sheets FILTER Function Examples
Use the FILTER function in Google Sheets to return matching rows by status, date, category, or multiple conditions.
FILTER returns rows or columns that match one or more conditions. Keep the output area blank, make every condition range the same size, and test one condition before adding more.
Check this first
- Make sure every condition range has the same height or width as the source range.
- Leave enough blank cells for the filtered result to expand.
- Use quotes around text criteria.
- Test each condition by itself before combining several filters.
Working examples
Filter rows where the status is Open
=FILTER(A2:D, D2:D="Open")Filter rows by status and minimum amount
=FILTER(A2:D, D2:D="Open", C2:C>=100)When FILTER is the right function
FILTER is best when you want a live view of rows that match a condition without manually hiding or copying data. It is useful for task lists, sales logs, form responses, and lightweight reporting sheets.
Because the result expands dynamically, it pairs well with clean source data and a reserved output area.
The most common mistake
The source range and condition ranges must line up. If you filter A2:D but use a condition like D:D, the mismatched size can cause confusing errors or unexpected results.
- Use A2:D with D2:D.
- Use A:D with D:D.
- Avoid mixing full-column and partial-column ranges in the same formula.
How to debug a FILTER formula
Start with one condition and confirm that it returns the expected rows. Then add the second condition, then the third. This prevents a single wrong criterion from making the whole result look empty.