How to sum by week in Excel
Formula (Excel and Google Sheets)
=SUMIFS($C$2:$C$11,$A$2:$A$11,">="&E2,$A$2:$A$11,"<"&E2+7)List the first day of each week and add the seven days from there: =SUMIFS($C$2:$C$11,$A$2:$A$11,">="&E2,$A$2:$A$11,"<"&E2+7).
- Result on the example
- one result per row in
F2, filled down toF4 - Works in
- Every current version
- Google Sheets
- Same formula
See it work
The formula is already in F2, filled down to F4. Change any input and the result updates, or edit the formula to experiment.
How it works
A week is a seven-day window: from the Monday in column E up to, but not including, the next Monday (E2+7). Using < for the end means Sunday March 8 counts in the first week and Monday March 9 starts the second.
=SUMIFS($C$2:$C$11,$A$2:$A$11,">="&E2,$A$2:$A$11,"<"&E2+7)Result562
$C$2:$C$1110 rows × 1 col: 148, 162, 155, 97, …A range: 10 cells in one column.
$A$2:$A$1110 rows × 1 col: Mar 2, 2026, Mar 4, 2026, Mar 6, 2026, Mar 8, 2026, …A range: 10 cells in one column.
E2Mar 2, 2026The value in E2.
">="&E2">=46083"The & operator joins as text.
E2+746090The + operator adds.
"<"&E2+7"<46090"The & operator joins as text.
SUMIFS($C$2:$C$11,$A$2:$A$11,">="&E2,$A$2:$A$11,"<"&E2+7)562SUMIFS: Adds values that meet every condition.- sum_range
$C$2:$C$1110 rows × 1 col: 148, 162, 155, 97, … - criteria_range1
$A$2:$A$1110 rows × 1 col: Mar 2, 2026, Mar 4, 2026, Mar 6, 2026, Mar 8, 2026, … - criteria1
">="&E2">=46083" - criteria_range2
$A$2:$A$1110 rows × 1 col: Mar 2, 2026, Mar 4, 2026, Mar 6, 2026, Mar 8, 2026, … - criteria2
"<"&E2+7"<46090"
- sum_range
In Google Sheets
The same formula works in Google Sheets: =SUMIFS($C$2:$C$11,$A$2:$A$11,">="&E2,$A$2:$A$11,"<"&E2+7). We ran it in Google Sheets mode on the same data and it returns the same results.
Other ways to do it
Each one was run on the same example sheet.
| Formula | Result | When to use it |
|---|---|---|
| =SUMPRODUCT(($A$2:$A$11-WEEKDAY($A$2:$A$11,3)=E2)*$C$2:$C$11) | 562, 503, 436 | Moves every date back to its Monday (WEEKDAY type 3 gives Monday = 0) and compares with E2. Handy when the week list is not in order. |
Common mistakes
- Using
"<="&E2+7counts the next Monday in two weeks. The end of the window must be strictly less than. - The dates in column E must be the real start of each week. A Wednesday in E2 sums Wednesday to Tuesday.
Try it yourself
Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.
Sum by week
F2, total the packages for the week starting on the Monday in E2, then fill down to F4.Questions
How do I sum by week number?
With WEEKNUM: =SUMPRODUCT((WEEKNUM($A$2:$A$11,2)=E2)*$C$2:$C$11) where E2 holds a week number. Use ISOWEEKNUM for ISO weeks, which start on Monday and can belong to the previous year.
How do I get the Monday of the week for a date?
Use =A2-WEEKDAY(A2,3). For weeks starting on Sunday, use =A2-WEEKDAY(A2)+1.
Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.