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 built-in spreadsheet rules in your browser and does not call an AI service.
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.