Formula guide · Google Sheets · Updated May 13, 2026
Google Sheets QUERY Multiple Conditions
Use QUERY with multiple where conditions in Google Sheets using and, or, dates, and text matches.
Quick Answer
Use and when every condition must be true, and use or when any condition can be true inside the QUERY where clause.
Copyable Formula
=QUERY(A1:D100,"select A, D where B = 'West' and C = 'Paid'",1)Syntax
=QUERY(A1:D100,"select A, D where B = 'West' and C = 'Paid'",1)Google Sheets
Worked Example
| A | B | C | D |
|---|---|---|---|
| Client | Region | Status | Amount |
| Acme | West | Paid | 300 |
| North Co | West | Open | 180 |
| Blue Lab | East | Paid | 420 |
Result: Returns Client and Amount only for rows where Region is West and Status is Paid.
Steps
- Write the select clause with the output columns you need.
- Add where and the first condition.
- Add and or or before each extra condition.
- Use single quotes around text values inside the query string.
Common Mistakes
- Using double quotes inside the query string without escaping them.
- Forgetting that QUERY uses column letters relative to the selected range.
- Mixing text and numbers in the same condition column.
Excel vs Google Sheets Notes
This page is focused on Google Sheets. Excel may require a different function, pivot table, or Power Query workflow.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.