Calculation Issues

How to Create a Cumulative Weekly Sales Total with SUMIFS in Excel

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 869 views

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.

How to Create a Cumulative Weekly Sales Total with SUMIFS in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the formula cell

Click the cell in your report where the cumulative weekly sales total should appear.

2
Enter the SUMIFS formula

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.

3
Test the drop-down selection

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.

4
Add a month-to-date lower boundary if needed

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).

Use SUMIFS with a Date Criterion to Total Sales Through the Selected Week
Cumulative total updates automatically: The total recalculates whenever the selected week drop-down changes, as long as the week-ending dates are real Excel dates.
WPS Office Spreadsheets

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. 1. Open your existing workbook: Launch WPS Office Spreadsheets and click Menu > Open, then select your Excel sales workbook.
  2. 2. Select the cumulative total cell: Click the report cell where the cumulative weekly sales total should appear.
  3. 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. 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. 5. Save in Excel-compatible format: Click Menu > Save As and choose .xlsx to keep the workbook compatible with Microsoft Excel.
Use Excel-compatible SUMIFS date criteria to total sales through any selected week.Open and save .xlsx files with full Microsoft Excel format compatibility.Free, lightweight Office suite with a familiar spreadsheet interface.Create drop-down-driven reports that recalculate automatically in WPS Office.
QA img-9

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.