Three conditions
=FILTER(A2:D,B2:B="West",C2:C>=1000,D2:D="Won")Adds a status test.
PASTE-READY RECIPE
FILTER with Multiple Conditions in Google Sheets
Return rows that meet two or more conditions at the same time.
QUICK ANSWER
The formula and where it fits.
Return rows that meet two or more conditions at the same time. Use =FILTER(A2:C,B2:B="West",C2:C>=1000), then replace the sample ranges with the columns in your sheet.
Each FILTER condition is an AND test when supplied as a separate argument.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Region | Sales |
| 2 | |||
| 3 | |||
| 4 | |||
| 5 |
FORMULA OUTPUTMaya · SamRecalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Cell-based criteria
=FILTER(A2:C,B2:B=F2,C2:C>=G2)Reads both criteria from cells.
Ignore no-match error
=IFERROR(FILTER(A2:C,B2:B=F2,C2:C>=G2),"No matches")Returns readable text when nothing qualifies.
COMMON ERRORS
When the result looks wrong.
FILTER has mismatched range sizes
Use the same starting and ending rows for the data and every condition range.
Numbers are stored as text
Convert the sales column to numbers before applying >=.
QUESTIONS
Answers before you paste.
FILTER has mismatched range sizes
Use the same starting and ending rows for the data and every condition range.
Numbers are stored as text
Convert the sales column to numbers before applying >=.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.