Excel formula builder
SUMIFS Formula Builder
Create a SUMIFS formula from ranges and criteria without uploading a sheet. Use normal criteria or switch the first criteria range into a month filter.
Builder inputs
Use A1-style ranges. Plain text criteria are quoted automatically.
=SUMIFS(D2:D100, B2:B100, "East", C2:C100, "Widget")=SUMIFS(D2:D100, B2:B100, "East", C2:C100, "Widget")Excel and Google Sheets use the same SUMIFS syntax for these criteria.How this formula works
- SUMIFS starts with the range to add, then accepts criteria range and criteria value pairs.
- For plain text, the builder adds quotes. For cell references, numbers, and expressions, it keeps the value unquoted.
- Month mode creates a start-of-month and next-month boundary using DATE, YEAR, MONTH, and EOMONTH.
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 sum range and all criteria ranges must be the same shape.
- Text criteria need quotes when written manually.
- For month filters, use real spreadsheet dates instead of text labels like Jan 2026.
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.