SUMIFS between two dates
SUMIFS adds the amounts whose date is on or after the start date and on or before the end date, with the dates read from cells.
=SUMIFS(C2:C500,A2:A500,">="&F1,A2:A500,"<="&F2)The sheet: Column A is a date, column C is an amount. F1 holds the start date and F2 the end date of the period you want to total.
How it works, step by step
- 01C2:C500 is the column being added up.
- 02A2:A500,">="&F1 keeps rows on or after the start date in F1.
- 03A2:A500,"<="&F2 keeps rows on or before the end date in F2.
- 04Only rows that pass both tests are included in the sum.
The same logic in four tools
=SUMIFS(C2:C500,A2:A500,">="&F1,A2:A500,"<="&F2)=SUMIFS(C2:C500,A2:A500,">="&F1,A2:A500,"<="&F2)SELECT SUM(amount)
FROM transactions
WHERE txn_date >= DATE '2026-03-01'
AND txn_date <= DATE '2026-03-31';mask = (df["date"] >= "2026-03-01") & (df["date"] <= "2026-03-31")
total = df.loc[mask, "amount"].sum()Mistakes that break it
- !The & joins the operator text and the cell. Writing ">=F1" inside quotes compares against the text F1.
- !If a date carries a time of day, "<="&F2 drops anything after midnight on the end date. Use "<"&F2+1 instead.
- !Dates stored as text are ignored. Check that they right-align in the cell.
Common questions
- How do I add a region condition too?
- Append another pair of arguments, for example ,B2:B500,"West". See SUMIFS with multiple criteria.
- Can I use the date directly instead of a cell?
- Yes, with ">="&DATE(2026,3,1).
Got a version of this with your own ranges?
Paste it into the free translator and get the same breakdown for your exact formula. To run it against a real file, upload the CSV and describe the formula you need in a sentence.