Exclusive end date
=SUMIFS(B2:B,A2:A,">="&E2,A2:A,"<"&F2)Leaves the end date out.
PASTE-READY RECIPE
Sum Between Two Dates in Google Sheets
Add amounts whose dates fall inside a start and end date.
QUICK ANSWER
The formula and where it fits.
Add amounts whose dates fall inside a start and end date. Use =SUMIFS(B2:B,A2:A,">="&E2,A2:A,"<="&F2), then replace the sample ranges with the columns in your sheet.
SUMIFS applies the lower and upper date bounds to the date column.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | B | |
|---|---|---|
| 1 | Date | Amount |
| 2 | ||
| 3 | ||
| 4 | ||
| 5 |
FORMULA OUTPUT440Recalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Current month
=SUMIFS(B2:B,A2:A,">="&EOMONTH(TODAY(),-1)+1,A2:A,"<="&EOMONTH(TODAY(),0))Uses the current calendar month.
Add a category
=SUMIFS(B2:B,A2:A,">="&E2,A2:A,"<="&F2,C2:C,G2)Limits the total to one category.
COMMON ERRORS
When the result looks wrong.
Dates are stored as text
Convert the date column to real dates before using SUMIFS.
End date is missing
Check that both date cells contain valid dates.
QUESTIONS
Answers before you paste.
Dates are stored as text
Convert the date column to real dates before using SUMIFS.
End date is missing
Check that both date cells contain valid dates.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.