FILTER with Multiple Conditions

Worked Example

Result: Returns only rows where Region is West and Status is Paid.

Steps

• Choose the full range you want to return.
• Wrap each condition in parentheses.
• Use * when every condition must be true.
• Use + when any condition can be true.

Common Mistakes

• Using AND() across full ranges and getting one result instead of row-by-row logic.
• Forgetting parentheses around each condition.
• Filtering ranges with different heights.

Excel vs Google Sheets Notes

The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.

FAQ