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.
Copyable formula
=SUMIFS(D2:D100, A2:A100, ">="&DATE(YEAR(F1),MONTH(F1),1), A2:A100, "<"&EOMONTH(F1,0)+1)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 |
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.