Syntax or pattern
Return rows from a range that match one or more conditions.
=FILTER(range, condition1, [condition2, ...])5 practical examples
Filter open tasks
Return only tasks marked Open.
=FILTER(A2:E, D2:D="Open")Adjust the ranges, criteria and sheet names to match your workbook.
Filter by owner and status
Build a simple view for one owner and status.
=FILTER(A2:F, B2:B=H2, E2:E="Ready")Adjust the ranges, criteria and sheet names to match your workbook.
Filter sales above a threshold
Show high-value sales rows.
=FILTER(A2:E, E2:E>=1000)Adjust the ranges, criteria and sheet names to match your workbook.
Filter by date range
Return records between two selected dates.
=FILTER(A2:E, A2:A>=H1, A2:A<=H2)Adjust the ranges, criteria and sheet names to match your workbook.
Filter non-empty rows
Remove blank rows from a report area.
=FILTER(A2:E, A2:A<>"")Adjust the ranges, criteria and sheet names to match your workbook.
Common mistakes to avoid
- Putting manual values inside a spill output range.
- Using full-column ranges on very heavy sheets without need.
- Forgetting that one formula can fill many rows.
FAQ
What is this Google Sheets page for?
This page gives copy-ready examples for filter examples so you can understand the pattern and adapt it to real spreadsheet work.
Can I copy these formulas directly?
Yes. Use the copy buttons, then adjust sheet names, ranges, criteria and column references for your own file.
Why does my formula return an error?
The most common causes are mismatched ranges, missing quotes around text criteria, blank source data, or references that do not match your sheet layout.