How to use FILTER with multiple conditions

Heads up: Excel and Google Sheets do this differently.

Excel

=FILTER(A2:A5,(B2:B5="East")*(C2:C5>150))

Google Sheets

=FILTER(A2:A5,B2:B5="East",C2:C5>150)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Campaign	Region	Amount
Alpha	East	120
Beta	West	200
Gamma	East	300
Delta	East	250

=FILTER(A2:A5,(B2:B5="East")*(C2:C5>150))→Gamma | Delta

Both expressions are checked against an independently calculated expected result in HyperFormula. This is a sample execution check, not native Excel or Google Sheets certification.

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2	Cell row 1 column 3
Cell row 2 column 1	Cell row 2 column 2	Cell row 2 column 3
Cell row 3 column 1	Cell row 3 column 2	Cell row 3 column 3
Cell row 4 column 1	Cell row 4 column 2	Cell row 4 column 3
Cell row 5 column 1	Cell row 5 column 2	Cell row 5 column 3

Formula

Runs server-side · free · no signup

Step by step

1Paste the four campaign rows at A1:C5 and choose an empty output column.
2Keep the output range and every criteria range aligned over rows 2 through 5.
3Use the Excel or Sheets expression shown. Both require East AND an amount greater than 150.
4Gamma and Delta satisfy both conditions, so their names spill into two rows in source order.

Tips

The worked example returns campaign names only, not the entire table. Native Excel/Sheets can return multiple columns; the bundled HyperFormula engine does not support all such FILTER shapes.
Excel's third FILTER argument is the empty-result fallback, not a second condition. Google Sheets returns #N/A when nothing matches; Excel without a fallback returns #CALC!. Keep spill cells clear.

Need the Google Sheets version instead? Open Sheets variant in workspace →

Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.

Frequently asked

Why multiply conditions in Excel?

The product is true only when both conditions are true. Adding conditions would instead express OR.

Which Excel versions support this?

Use Microsoft 365, Excel 2021 or Excel 2024. Older versions need another filtering method.

Sources and compatibility

Reviewed 2026-09-16

Formulas used

FILTER IF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: September 16, 2026