How to Create a Cumulative Weekly Sales Total with SUMIFS in Excel
Question details
The user needs a formula to calculate cumulative weekly sales through a selected week rather than only the selected week's sales, using week-ending dates in column B and a drop-down week selector.

- Product
- WPS Office Spreadsheets (Excel-compatible)
- Device & OS
- not provided
- Scenario
- A sales report uses week-ending dates in column B and weekly sales in column C. The selected week is chosen from a drop-down list, and the report should show cumulative totals through that week.
- Observed behavior
- The current report shows only the individual selected week's sales instead of all sales through the selected week.
Confirm that week-ending dates are real Excel dates in column B and that sales values are numeric in column C. Make sure the selected week cell, such as C6, is also a valid date and uses the same date format as column B.
Use SUMIFS with a Date Criterion to Total Sales Through the Selected Week
Use this when you want a single dynamic cumulative total that updates automatically as the selected week changes.
SUMIFS adds only the rows where the week-ending date in column B is less than or equal to the selected week in C6. The formula can start from a fixed row so all earlier weeks in the sales range are included.
Click the cell in your report where the cumulative weekly sales total should appear.
Type =SUMIFS(Sales!C$4:C$55,Sales!B$4:B$55,"<="&C6) and press Enter. Replace Sales!C$4:C$55 with the weekly sales range, Sales!B$4:B$55 with the week-ending date range, and C6 with the selected-week cell.
Change the selected week in the drop-down list and confirm the formula returns all sales through that week instead of only that week's sales.
For a month-to-date total, add a second condition for the first day of the selected month, for example using DATE(YEAR(C6),MONTH(C6),1).

Create a Row-by-Row Cumulative Weekly Total with SUMIFS and MAX
Use this when your report already has one row per week and you want each row to show the cumulative amount through that row's week-ending date.
Create a Cumulative Weekly Sales Total in WPS Office Spreadsheets
WPS Office Spreadsheets supports Excel-style SUMIFS formulas and .xlsx workbooks, so you can build a dynamic weekly sales report with a drop-down week selection and cumulative totals without changing your workflow.
- 1. Open your existing workbook: Launch WPS Office Spreadsheets and click Menu > Open, then select your Excel sales workbook.
- 2. Select the cumulative total cell: Click the report cell where the cumulative weekly sales total should appear.
- 3. Enter the SUMIFS formula: Type =SUMIFS(Sales!C$4:C$55,Sales!B$4:B$55,"<="&C6) and press Enter, replacing the ranges and selected-week cell to match your report.
- 4. Test the selected week drop-down: Change the drop-down selection and verify that the total updates to include all sales through the selected week.
- 5. Save in Excel-compatible format: Click Menu > Save As and choose .xlsx to keep the workbook compatible with Microsoft Excel.

Frequently Asked Questions
Why does my SUMIFS formula return 0 or no match?
Check that the week-ending dates in column B and the selected-week cell are entered as real dates, not text. The comparison must be written as "<="&C6 with the ampersand outside the quotes.
Can I limit the cumulative total to only the selected month?
Yes. Add a second SUMIFS condition for the first day of the selected month, such as using DATE(YEAR(C6),MONTH(C6),1) as the lower date boundary.
Does this cumulative SUMIFS formula work in WPS Office Spreadsheets?
Yes, WPS Office Spreadsheets supports SUMIFS and Excel-style formulas, so the same formula works when you open .xlsx workbooks in WPS Office.
What is the difference between summing a selected week and summing through the selected week?
A selected-week total uses only rows whose week-ending date equals the selected week. A cumulative total uses a date condition such as "<="&C6 to include every week-ending date up to and including the selected week.




