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.
Best fit
Best for
- Totals by region, product, status, category, owner, or month.
- Monthly reporting tables where every row has one amount to add.
- Criteria that can be written as exact text, cell references, numbers, or operator criteria.
Not for
- Counting matching rows. Use COUNTIFS when you need a row count instead of a total.
- Returning the matching rows themselves. Use FILTER or QUERY when you need the row details.
- OR logic across many possible values unless you are comfortable adding multiple SUMIFS formulas.
Useful formula variations
=SUMIFS(D2:D100, A2:A100, ">="&DATE(YEAR(F1),MONTH(F1),1), A2:A100, "<"&EOMONTH(F1,0)+1)Use this when F1 contains any real date in the month you want to report.
=SUMIFS(D2:D100, A2:A100, ">="&F1, A2:A100, "<"&G1)Use < the day after the end date when source cells may contain times.
=SUMIFS(D2:D100, B2:B100, "East", D2:D100, ">=300")Operator criteria such as >=300 must be inside quotes when written manually.
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 |
Troubleshooting
| Problem | Likely cause | Fix |
|---|---|---|
| Formula returns 0 | Criteria text, date values, or range shapes do not match the source data. | Check for extra spaces, real date values, and same-height ranges before changing the formula. |
| Month formula misses rows | The month cell is text or the end boundary uses <= with time values. | Use a real date in the month cell and the < next month pattern. |
| Formula errors after adding a second criterion | The optional criteria range and criteria value were not filled together. | Use complete range/value pairs or leave both optional fields empty. |
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.