Skip to content
Google Sheets

FILTER function in Google Sheets

Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.

=FILTER(range, condition1, [condition2, ...])

FILTER syntax and parameters

Three arguments, two required.

  • rangerangeRequired

    The data to be filtered.

  • condition1arrayRequired

    A column or row containing true or false values corresponding to the first column or row of range, or an array formula evaluating to true or false.

  • condition2arrayRepeating

    [ OPTIONAL ] - Additional rows or columns containing boolean values TRUE or FALSE indicating whether the corresponding row or column in range should pass through FILTER. Can also contain array formula expressions which evaluate to such rows or columns. All conditions must be of the same type (row or column). Mixing row conditions and column conditions is not permitted. condition arguments must have exactly the same length as range.

FILTER examples

Formulas you'll actually reuse.

  1. Deals over $1,000 — open-ended ranges keep new rows included:

    =FILTER(A2:C, C2:C > 1000)

  2. AND two conditions; IFERROR supplies the empty-state message:

    =IFERROR(FILTER(A2:C, (B2:B = "West") * (C2:C > 1000)), "No matches")

FILTER in Excel

Same name — your formula ports as-is.

Try FILTER in the playground

Edit the example — nothing to install.

Preloaded with the FILTER formula from Example 1 — change anything and watch it respond.

Loading the editor…

FILTER errors

What they mean — and the fixes.

  • #N/A

    Nothing matched the condition — wrap the FILTER in IFERROR to show a message instead.

Related functions

More ways Google Sheets gets this done.