This tutorial shows how to Sum by week in Excel using the example below;
To sum by week, you can use a formula based on the SUMIFS function. In the example shown, the formula in F4 is:
This formula uses the named ranges “amount” (C4:C21) and “date” (B4:B21).
How this formula works
The SUMIFS function can sum ranges based on multiple criteria.
In this problem, we configure SUMIFS to sum amounts by week using two criteria: (1) dates greater than or equal to the date in column E, (2) dates less than the date in column E plus 7 days:
When this formula is copied down, SUMIFS generates a sum for each week.
The dates in column E are Mondays. The first date is hard-coded, and the rest of the Mondays are calculated with a simple formula: