Google Sheets formula builder
FILTER Formula Builder
Generate FILTER formulas for Excel dynamic arrays and Google Sheets using local deterministic logic.
Builder inputs
Use the data range to return, then add one or two condition ranges.
=FILTER(A2:D100, (B2:B100="East")*(D2:D100>=300), "No matches")=IFERROR(FILTER(A2:D100, B2:B100="East", D2:D100>=300), "No matches")Excel combines multiple FILTER conditions with multiplication. Google Sheets passes each condition as a separate argument.How this formula works
- FILTER returns rows from the data range where conditions evaluate to TRUE.
- Excel uses one include argument, so multiple conditions are multiplied together.
- Google Sheets accepts each condition as a separate argument after the data range.
Sample data
| Date | Region | Product | Amount |
|---|---|---|---|
| 2026-01-04 | East | Widget | 420 |
| 2026-01-12 | West | Widget | 310 |
| 2026-02-03 | East | Gadget | 275 |
| 2026-02-15 | East | Widget | 640 |
Common mistakes
- The condition ranges must align with the rows in the data range.
- Text values need quotes when written manually.
- FILTER spills results, so blocked output cells can cause a spill error.
Related formulas
FAQ
Are these formulas generated with AI?
No. The builder uses deterministic TypeScript functions in the browser and does not call any AI API.
Do I need to upload my spreadsheet?
No. Enter ranges and criteria manually. The site does not upload, store, or process spreadsheet files.
Can I copy the generated formula?
Yes. Each output includes a copy button so you can paste the formula into Excel or Google Sheets.