SheetSense

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.

fx
=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

  1. 01C2:C500 is the column being added up.
  2. 02A2:A500,">="&F1 keeps rows on or after the start date in F1.
  3. 03A2:A500,"<="&F2 keeps rows on or before the end date in F2.
  4. 04Only rows that pass both tests are included in the sum.

The same logic in four tools

Excel
=SUMIFS(C2:C500,A2:A500,">="&F1,A2:A500,"<="&F2)
Google Sheets
=SUMIFS(C2:C500,A2:A500,">="&F1,A2:A500,"<="&F2)
SQL
SELECT SUM(amount)
FROM transactions
WHERE txn_date >= DATE '2026-03-01'
  AND txn_date <= DATE '2026-03-31';
Python (pandas)
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.