Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to use SUMIFS between two dates in Excel and Google Sheets
Topic:SUMIF & SUMIFSExcel & Google Sheets
=SUMIFS($B$2:$B$5,$A$2:$A$5,">="&DATE(2024,1,1),$A$2:$A$5,"<="&DATE(2024,2,28))✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Date | Revenue |
| 2024-01-10 | 1200 |
| 2024-01-28 | 800 |
| 2024-02-15 | 950 |
| 2024-03-05 | 1100 |
=SUMIFS($B$2:$B$5,$A$2:$A$5,">="&DATE(2024,1,1),$A$2:$A$5,"<="&DATE(2024,2,28))→0
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Identify your date column (e.g. A) and value column (e.g. B), and your start and end dates.
- 2Apply the first criterion: $A$2:$A$100,">="&startDate to include dates on or after the start.
- 3Add the second criterion on the same date column: $A$2:$A$100,"<="&endDate. Combined: =SUMIFS($B$2:$B$100,$A$2:$A$100,">="&E1,$A$2:$A$100,"<="&E2) where E1 holds the start and E2 the end date.
Tips
- Store the start and end dates in separate cells and reference them in the formula so you can adjust the date range without editing the formula itself.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I use SUMIFS to sum by month without specifying exact dates?
Use EOMONTH to dynamically compute month boundaries: start =DATE(YEAR(E1),MONTH(E1),1) and end =EOMONTH(E1,0) where E1 is any date within the target month.
More on SUMIF & SUMIFS
See all →Reference
SUMIF
Add up the cells in a range that meet a single condition.
How-toSUMIF vs SUMIFS: when to use each in Excel and Sheets
Understand when to use SUMIF (one condition) versus SUMIFS (multiple conditions) for conditional summing in Excel and Google Sheets.
Error fixFix 0
SUMIF returns 0 instead of the expected total in Excel and Google Sheets — fix number-as-text, criteria mismatch, range size errors, and data-type issues.
ReferenceSUMIFS
Sum values that meet multiple conditions at once.
How-toHow to use SUMIF with a date range
Use SUMIF with a date comparison criterion to sum values only for dates on or after (or before) a specific date in your data range.
Error fixFix SUMIF
SUMIF not working in Excel and Google Sheets — diagnose formula errors, criteria syntax problems, range mismatches, and wildcard issues.