Formula example
SUMIFS by Month in Excel
You have daily sales rows and want to total the Amount column for all rows that fall inside the month stored in F1. If you searched for SUMIF by month, use the Excel SUMIF by month page first to see why this example uses SUMIFS.
Copyable formula
=SUMIFS(D2:D100, A2:A100, ">="&DATE(YEAR(F1),MONTH(F1),1), A2:A100, "<"&EOMONTH(F1,0)+1)If F1 is 2026-01-01 and the sample data is used, the formula returns 730 because it adds the January rows: 420 + 310.
Useful variations
=SUMIFS(D2:D100, A2:A100, ">="&DATE(2026,1,1), A2:A100, "<"&DATE(2026,2,1))Use this only when the month will not change. A month cell is easier to reuse.
=SUMIFS(D2:D100, A2:A100, ">="&DATE(YEAR(F1),MONTH(F1),1), A2:A100, "<"&EOMONTH(F1,0)+1, B2:B100, "East")Add another criteria pair when you need a month total for one region, product, or status.
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 |
When to use this formula
- Use this when source rows contain daily dates and you want one monthly total.
- Use a real date cell such as 2026-01-01 in F1, even if the cell is formatted to show only January.
- Use the SUMIFS builder when you need to add product, region, owner, or status criteria.
Returned totals from the sample data
| Formula setup | Returned result | Rows included |
|---|---|---|
| F1 contains any January 2026 date | 730 | 2026-01-04 East Widget 420 plus 2026-01-12 West Widget 310. |
| F1 contains any February 2026 date | 915 | 2026-02-03 East Gadget 275 plus 2026-02-15 East Widget 640. |
| January 2026 plus Region = East | 420 | Only the 2026-01-04 East Widget row. |
Formula explanation
- The first date criterion starts at the first day of the selected month.
- The second date criterion stops before the first day after that month.
- Using date boundaries is safer than comparing formatted month text.
Common errors
- F1 must contain a real date, not only the text January.
- The date range and sum range must cover the same rows.
- Use < next month instead of <= end of month when source values may contain times.
Build your own version
Use the deterministic builder for this pattern: SUMIFS Formula Builder.
Related formulas
FAQ
Does this work in Google Sheets?
Yes. SUMIFS, DATE, YEAR, MONTH, and EOMONTH are available in Google Sheets.
Can I use a typed month name?
A real date cell is more reliable than a typed month name.