Calculate a Month-to-Date Total by Week in Excel
Question details
Calculate the cumulative total for a selected month through a selected week.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains monthly volumes by week, and the user wants a total through a chosen week, such as Week 3.
- Observed behavior
- The desired result includes volumes from the selected month up to and including the chosen week, rather than the entire month's total.
Check that each row has a month identifier, a numeric week number, and a numeric volume. Use a month identifier that includes the year if the data spans multiple years.
Use SUMIFS to Total the Selected Month Through a Week
Use this formula when each row has a month identifier, week number, and volume.
SUMIFS adds volumes only when the month matches the selected month and the week number is less than or equal to the selected week. The week numbers must be consistent within each month.
Place month identifiers in column A, numeric week numbers in column B, and volumes in column C. Each row should be assigned to the month it contributes to.
Enter the desired month in E1 using the same format as column A, and enter the last week to include as a number in E2.
Select an empty cell and enter =SUMIFS(C:C,A:A,E1,B:B,"<="&E2). Press Enter to calculate the total through the selected week.
Change E2 to 3 and confirm that the result includes the selected month's volumes for Weeks 1 through 3, but not later weeks.

Calculate a Month-to-Date Weekly Total in WPS Spreadsheets
Use SUMIFS in WPS Spreadsheets to add a selected month's volumes through the week you specify.
- 1. Open the workbook: Open WPS Spreadsheets and select Open to load your workbook, or create a new spreadsheet.
- 2. Set up the data: Put month identifiers in column A, numeric week numbers in column B, and volumes in column C.
- 3. Choose the month and week: Enter a matching month identifier in E1 and the last week to include in E2.
- 4. Enter the formula: Select an empty cell, enter =SUMIFS(C:C,A:A,E1,B:B,"<="&E2), and press Enter.

Frequently Asked Questions
Does the formula include the selected week?
Yes. The criterion "<="&E2 includes the week number in E2 and all lower week numbers for the selected month.
Why does the formula return zero?
Check that E1 matches the month values in column A, E2 and column B contain numeric week numbers, and column C contains numeric volumes.
How do I avoid combining the same month across different years?
Use a month identifier that includes the year in column A, such as Jan 2026, and enter the same identifier in E1.
Can I calculate the total using dates instead of week numbers?
Yes. Use SUMIFS with a start date for the month and an end boundary for the selected week. The exact formula depends on how your dates and week boundaries are defined.




