sumifs from week number to Month

[aarti_rto]

Hello,

i have below week wise upcoming shipment data in a sheet

Week No
Part No	18​	19​	20​	21​	22​	23​	24​	25​
A	41​	0​	18​	85​	42​	81​	0​	49​
B	0​	3​	55​	0​	17​	0​	73​	0​
C	34​	9​	5​	54​	29​	0​	92​	0​
D	59​	20​	0​	31​	27​	20​	98​	26​

and i need monthly total in another sheet.

for example i need below data from above table.

Month
Part No	May-23​	Jun-23​
A	186​	130​
B	75​	73​
C	131​	92​
D	137​	144​

kindly suggest.

 

[Trevor G]

Quick question, in your first table within your thread are the numbers 18, 19, 20, 21 representing May as the month to give you the total 186, and 22, 23, 24 and 25 to give you the 130 total for part A? And the subsequent rows for the other parts?

 

[aarti_rto]

yes, the numbers represent calendar weeks..

 

[Trevor G]

As the two lists of parts are the same all you need to use is a Sum function, summing 4 cells for each month as there will only ever be 4 weeks in a month. So Jan (01) would be =Sum(b3:e3). Feb (02) would be =Sum(f3:i3) and so on. That would give you the totals by each month and then fill the formula down till the last product and you should have your solution unless I'm missing something?