OR across columns
=FILTER(A2:C,(B2:B="West")+(C2:C>=2000))Matches either a region or a sales threshold.
PASTE-READY RECIPE
FILTER Using OR Conditions in Google Sheets
Return rows when either of two or more conditions is true.
QUICK ANSWER
The formula and where it fits.
Return rows when either of two or more conditions is true. Use =FILTER(A2:C,(B2:B="West")+(B2:B="East")), then replace the sample ranges with the columns in your sheet.
Adding Boolean tests creates OR logic inside FILTER.
- 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 · LeoRecalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Several allowed values
=FILTER(A2:C,COUNTIF(F2:F4,B2:B)>0)Reads an allowed list from F2:F4.
OR plus AND
=FILTER(A2:D,((B2:B="West")+(B2:B="East"))*(D2:D="Won"))Groups the OR test, then applies status.
COMMON ERRORS
When the result looks wrong.
Using commas creates AND
Add the Boolean tests together when you need OR.
Whole-column arrays are slow
Use bounded ranges in very large files.
QUESTIONS
Answers before you paste.
Using commas creates AND
Add the Boolean tests together when you need OR.
Whole-column arrays are slow
Use bounded ranges in very large files.
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.