The SUMIFS with dates guide
=SUMIFS(C2:C15, A2:A15, ">="&G1, A2:A15, "<="&G2) adds up the amounts whose date is from G1 to G2. When the dates carry a time, the last day needs "<"&G2+1 instead.
Two tests on the same column
=SUMIFS(sum_range, dates, ">="&start, dates, "<="&end)
SUMIFS adds a row only when every test is true, so a start test and an end test on the same date column keep the rows in between. ">=" includes the start day; ">" would leave it out.
The operator goes in quotes, the cell outside
">="&G1 joins the operator to the date in G1. Written as ">=G1", SUMIFS compares every date with the letters G1 and adds nothing. Typing the date into the criterion, ">=1/1/2026", works until the period changes, and on a computer set to day-first dates it reads as a different day.
Dates with times
Till and system exports often include the time: 3/31/2026 16:20. Excel stores that as the date plus a fraction of a day, so it is later than 3/31/2026 itself, which is midnight. "<="&G2 leaves the whole afternoon out. "Before the next day starts" keeps it: "<"&G2+1. That form is right whether or not the dates have times, so it's a safe habit.
More conditions
Add pairs for anything else: =SUMIFS(C2:C15, A2:A15, ">="&G1, A2:A15, "<"&G2+1, B2:B15, G3) is one region in the period. COUNTIFS takes the same tests to count the sales instead.
Common mistakes
- ">" for the start. The first day's sales drop out.
- Only one date test. Everything after the start date is added, next month included.
- Dates stored as text. Text never passes a number test, so those rows are skipped without a warning. Convert them first, as in the DATEVALUE lesson.
SUMIFS with text conditions first: SUMIFS practice.
FAQ
- How do I sum values between two dates in Excel?
- Use SUMIFS with two tests on the date column: =SUMIFS(C:C,A:A,">="&G1,A:A,"<="&G2), with the start date in G1 and the end date in G2.
- Why does SUMIFS with dates return 0?
- Often the cell is inside the quotes (">=G1" instead of ">="&G1), or the dates are stored as text.
- How do I include the end date when the dates have times?
- Test for before the next day: "<"&G2+1. A date with a time is later than the date alone, so "<="&G2 leaves it out.
- Can SUMIFS use a date range and another condition?
- Yes. Add more range and criteria pairs, such as B2:B15,G3 for one region.



































































