Calculation Issues

Calculate a Month-to-Date Total by Week in Excel

Anum MushtaqAnum Mushtaq Nov 18, 2026 868 views

Question details

Calculate the cumulative total for a selected month through a selected week.

Calculate a Month-to-Date Cumulative Total by Week in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Arrange the source data

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.

2
Enter the selection

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.

3
Calculate the total

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.

4
Check the result

Change E2 to 3 and confirm that the result includes the selected month's volumes for Weeks 1 through 3, but not later weeks.

Use SUMIFS to Total the Selected Month Through a Week
Match the month identifier: If column A uses text such as Jan 2026, enter the same text in E1. If it uses actual dates, E1 must match the date values used in column A; otherwise, use suitable date boundaries instead.
Calculate by week in WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and select Open to load your workbook, or create a new spreadsheet.
  2. 2. Set up the data: Put month identifiers in column A, numeric week numbers in column B, and volumes in column C.
  3. 3. Choose the month and week: Enter a matching month identifier in E1 and the last week to include in E2.
  4. 4. Enter the formula: Select an empty cell, enter =SUMIFS(C:C,A:A,E1,B:B,"<="&E2), and press Enter.
Calculate cumulative totals through a selected week.Open and edit Microsoft Excel XLSX and XLS files.Change the selected month or week without rewriting the formula.
microsoft office alternative - wps office

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.