Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to sum values between two dates in Excel and Google Sheets
Topic:SUM & aggregationExcel & Google Sheets
=SUMIFS(B2:B5,A2:A5,">="&DATE(2024,1,1),A2:A5,"<="&DATE(2024,6,30))✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Date | Sales |
| 2024-01-15 | 500 |
| 2024-04-20 | 300 |
| 2024-08-10 | 700 |
| 2025-01-05 | 400 |
=SUMIFS(B2:B5,A2:A5,">="&DATE(2024,1,1),A2:A5,"<="&DATE(2024,6,30))→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
- 1Put dates in column A and numeric values in column B.
- 2Enter =SUMIFS(B2:B5,A2:A5,">="&DATE(2024,1,1),A2:A5,"<="&DATE(2024,6,30)). The & concatenates the operator string with the date serial number returned by DATE().
- 3Press Enter. Rows with dates on or after 2024-01-01 AND on or before 2024-06-30 are included in the sum.
Tips
- Store start and end dates in cells (e.g. D1 and D2) and use ">="&D1 and "<="&D2 to make the formula reusable.
- Avoid putting dates directly as text inside the criteria string (e.g. ">="&"2024-01-01") — locale differences can cause mismatches. Use DATE() or a cell reference instead.
- If your dates include time components (datetime values), use < instead of <= for the end boundary and set it to the next day to catch all times on the last day.
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
Why does the formula return 0 when I know there are matching dates?
The most common cause is dates stored as text strings rather than real date serial numbers. Try =ISNUMBER(A2) — if FALSE, convert with DATEVALUE().
Can I sum between dates that include a specific month only?
Yes: =SUMPRODUCT((MONTH(A2:A5)=3)*B2:B5) sums all March values regardless of year.
More on SUM & aggregation
See all →Reference
SUMPRODUCT
Multiply ranges together row by row and sum the result — ideal for weighted totals.
How-toHow to sum a column
Add up an entire column with SUM. Total a whole column or a fixed range — identical in Excel and Google Sheets.
Error fixFix 0
SUM returns 0 or the wrong total in Excel and Google Sheets — fix numbers stored as text, filtered ranges, manual calculation mode, and circular references.
ReferenceSUBTOTAL
Aggregate a range (sum, average, count…) while ignoring other SUBTOTALs and, optionally, hidden rows. Ideal under filters.
How-toHow to create a running total
Build a cumulative running total with a SUM and a clever anchored reference that grows as you copy it down. Works in both apps.
How-toHow to sum values by month
Total amounts that fall in a given month with SUMIFS and two date bounds. Works the same in Excel and Google Sheets.