How to Use FILTER with Multiple Conditions in Excel

Q: Can FILTER sort too?

Wrap it: =SORT(FILTER(...),3,-1).

How to Use the FILTER Function in Excel with Multiple Conditions

By Rinkesh Shah · Business Analyst, 8 years in data · Updated 2026-10-31

▶ Video coming soon

FILTER returns only the rows that meet your conditions, as a live list that updates when the data changes.

Syntax

=FILTER(array, include, [if_empty])

array is the data to return, include is the test, and if_empty is the text to show when nothing matches.

One condition

=FILTER(A2:D100, C2:C100="North") returns all rows where region is North.

AND: multiply the conditions

=FILTER(A2:D100, (C2:C100="North")*(D2:D100>5000))

The result is a row only when both tests are true.

OR: add the conditions

=FILTER(A2:D100, (C2:C100="North")+(C2:C100="South"))

A row is returned when either test is true.

Show a message when nothing matches

=FILTER(A2:D100, C2:C100="East", "No results")

Filter and sort together

=SORT(FILTER(A2:D100, C2:C100="North"), 4, -1) sorts the filtered rows by the 4th column, largest first.

Tips

The include range must have the same number of rows as the array.
Always wrap each condition in brackets when using * or +.
Leave empty space below and beside the formula so it can spill.

Worked example

Show rows where region is North and sales above 1000: =FILTER(A2:C100,(A2:A100="North")*(C2:C100>1000),"No match"). For OR use + instead of *.

Common mistakes

Using AND() inside FILTER. It returns one answer, not one per row. Use * instead.
Forgetting the if-empty argument, so you see #CALC!.
Spill area blocked.

Frequently asked questions

How do I do OR?

Add conditions with +.

Can FILTER sort too?

Wrap it: =SORT(FILTER(...),3,-1).

Does it work in old Excel?

No. It needs Excel 2021 or Microsoft 365.

Practice this online, free

Reading is only half of learning Excel. Cellgrids is a free place for online Excel practice: solve Excel formula exercises in a live spreadsheet, prepare for Excel interview questions, and work through business case studies built for data analytics and business analytics roles.

Practice these formulas: FILTER, SORT, UNIQUE.

Start Excel practice → Case studies