Google Sheets Function: FILTER

The FILTER function returns a filtered version of a range, with only the rows or columns that meet the specified conditions.


=FILTER(range, condition)


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

Example of use

The FILTER function will return in the right-side table all the rows of unpaid purchases (in other words, rows where the payment date is empty):

google sheets function filter

Enter in the FILTER function:

The formula here is:

google sheets function filter table

Adding more conditions

The FILTER function allows specifying multiple conditions by adding them in sequence.

For example, to filter unpaid purchases and those where the purchase date is more than 30 days old, add an additional condition:

google sheets function filter table extended
If needed, you can copy the Google Sheets document (or view the document) with these examples.