SUMIF between Two Dates Excel
Summing amounts between two dates is one of those tasks that should not require filtering the sheet every time. The reliable method is to test the date column twice: once for the start date and once for the end date. This example shows the exact SUMIFS pattern for a date range.
Formula Syntax
Use this base syntax for sumif between two dates excel and replace the ranges with your own spreadsheet columns.
SUMIFS(sum_range, date_range, ">="&start_date, date_range, "<="&end_date)Need this formula for your exact sheet?
Generate a custom sumif between two dates excel formula with your own columns, criteria, and spreadsheet layout.
Step-by-step Example
A marketing finance spreadsheet tracks Campaign spend window and needs a formula-driven result instead of manual filtering.
| Date | Spend |
|---|---|
| 2026-03-01 | $90 |
| 2026-03-12 | $140 |
| 2026-04-03 | $60 |
Resulting formula
=SUMIFS(B:B,A:A,">="&DATE(2026,3,1),A:A,"<="&DATE(2026,3,31))The formula evaluates the Campaign spend window rows and returns $230. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.
Try It Now
The generator is pre-filled for sumif between two dates excel. Edit the prompt to match your columns, criteria, and spreadsheet layout.
Generated formula
How it works
Need more formulas every day?
HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.
- ✓ Higher daily formula generation limits
- ✓ Saved formula history for reuse
- ✓ Excel formula language selection
Common Variations
- Include the end date
- Use cell references for dates
- Sum between dynamic dates
FAQ
How do I set up SUMIF between Two Dates Excel for Campaign spend window?
Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.
Can this formula handle include the end date?
Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for include the end date. If the logic becomes more complex, generate a custom version with the free tool.
What should I check if the SUMIF between Two Dates Excel result is wrong?
Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the Campaign spend window fields are formatted consistently.