Google Sheets function
FILTER function in Google Sheets
FILTER in Google Sheets returns only the rows or columns from a source range that meet supplied TRUE or FALSE conditions. Every condition must match the range length and use the same row or column orientation. If no value meets the conditions, FILTER returns #N/A.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=FILTER(range, condition1, [condition2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
range | Yes | The source data to filter. |
condition1 | Yes | A matching row or column of TRUE and FALSE values, or an expression that produces them. |
condition2, ... | No | Additional conditions with the same orientation and length. |
Examples
Show open tasks
| A | B | |
|---|---|---|
| 1 | Task | Status |
| 2 | Draft | Open |
| 3 | Review | Done |
| 4 | Publish | Open |
=FILTER(A2:B4,B2:B4="Open")Result: Draft | Open; Publish | Open
FILTER returns the two rows whose status evaluates to TRUE.
Common mistakes
Using a condition range with a different number of rows.
Make each condition exactly as long as the source range.
Mixing row conditions and column conditions in one call.
Filter rows or columns in one call, not both at once.