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.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
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.