Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to use SUMIF with a date range in Excel and Google Sheets
Topic:SUMIF & SUMIFSExcel & Google Sheets
=SUMIF($A$2:$A$5,">="&DATE(2024,2,1),$B$2:$B$5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Date | Amount |
| 2024-01-15 | 500 |
| 2024-02-03 | 750 |
| 2024-02-20 | 600 |
| 2024-03-10 | 900 |
=SUMIF($A$2:$A$5,">="&DATE(2024,2,1),$B$2:$B$5)→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
- 1Ensure your date column contains real date values, not text.
- 2Construct the criteria by concatenating a comparison operator with a DATE value: ">="&DATE(2024,2,1) means 'on or after February 1, 2024'.
- 3Write the full formula: =SUMIF($A$2:$A$100,">="&DATE(2024,2,1),$B$2:$B$100). For a date stored in a cell (e.g. E1), use ">="&E1.
Tips
- Never write the date as a hardcoded string like ">=2024-02-01" — date string parsing is locale-dependent. Always use DATE() or a cell reference to guarantee the correct serial number.
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 sum for a single specific date?
Use the date as an exact criterion without an operator: =SUMIF($A$2:$A$100,DATE(2024,2,1),$B$2:$B$100). This sums only rows where the date equals February 1, 2024.
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 SUMIFS between two dates
Use SUMIFS with two date criteria on the same date column to sum values that fall within a specific start and end date range.
Error fixFix SUMIF
SUMIF not working in Excel and Google Sheets — diagnose formula errors, criteria syntax problems, range mismatches, and wildcard issues.