Spreadsheet: 843149d1695091858-sumif-multiple-criteria-into-months-or-use-pivot-table-dataset-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Method 1 - Manual sum |  |  |  |  |  |  | Method 2 - sumifs add together |  |  |  |  |  |  | Method 3 - one formula approach?
Dept | Dept Name | Customer SKU | Description | UPC | Model# | Measure | 9/11/23 | 9/18/23 | 9/25/23 | 10/2/23 | 10/9/23 | 10/16/23 | 10/23/23 | 10/30/23 | 11/6/23 | 11/13/23 | 11/20/23 | 11/27/23 | 12/4/23 | 12/11/2023 | 12/18/2023 | 12/25/2023 |  | Customer SKU | Measure | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  | Customer SKU | Measure | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  | sumproduct + index match combo function?
2 | PC&Mac Input/Output | 50497228 | Description 1 | 1 |  | On Order Qty | 0 | 130 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 50497228 | On Order Qty |  |  |  |  |  | 50497228 | On Order Qty |  |  |  |  |  | Pivot table to automate?
2 | PC&Mac Input/Output | 50497228 | Description 1 | 1 |  | Plan Receipt | 0 | 130 | 0 | 50 | 10 | 30 | 50 | 80 | 80 | 60 | 70 | 120 | 130 | 60 | 50 | 50 |  | 50497228 | Plan Receipt |  |  |  |  |  | 50497228 | Plan Receipt
2 | PC&Mac Input/Output | 43552159 | Description 2 | 2 |  | On Order Qty | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 43552159 | On Order Qty |  |  |  |  |  | 43552159 | On Order Qty
2 | PC&Mac Input/Output | 43552159 | Description 2 | 2 |  | Plan Receipt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 10 | 0 | 20 | 10 | 20 | 0 | 0 |  | 43552159 | Plan Receipt |  |  |  |  |  | 43552159 | Plan Receipt
2 | PC&Mac Input/Output | 23613552 | Description 3 | 3 |  | On Order Qty | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 23613552 | On Order Qty |  |  |  |  |  | 23613552 | On Order Qty
2 | PC&Mac Input/Output | 23613552 | Description 3 | 3 |  | Plan Receipt | 0 | 0 | 0 | 36 | 0 | 0 | 0 | 12 | 12 | 30 | 24 | 12 | 12 | 12 | 6 | 12 |  | 23613552 | Plan Receipt |  |  |  |  |  | 23613552 | Plan Receipt
5 | PC & Mac Accessories | 34824773 | Description 4 | 4 |  | On Order Qty | 0 | 0 | 0 | 360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 34824773 | On Order Qty |  |  |  |  |  | 34824773 | On Order Qty
5 | PC & Mac Accessories | 34824773 | Description 4 | 4 |  | Plan Receipt | 0 | 0 | 0 | 360 | 0 | 0 | 30 | 60 | 30 | 60 | 60 | 60 | 60 | 30 | 90 | 60 |  | 34824773 | Plan Receipt |  |  |  |  |  | 34824773 | Plan Receipt
2 | PC&Mac Input/Output | 44916798 | Description 5 | 5 |  | On Order Qty | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 44916798 | On Order Qty |  |  |  |  |  | 44916798 | On Order Qty
2 | PC&Mac Input/Output | 44916798 | Description 5 | 5 |  | Plan Receipt | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 5 | 10 | 5 | 10 | 10 | 0 | 5 | 0 |  | 44916798 | Plan Receipt |  |  |  |  |  | 44916798 | Plan Receipt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer SKU | Measure | September | October | November | December
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23613552 | On Order Qty | 0 | 36 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23613552 | Plan Receipt | 0 | 48 | 78 | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34824773 | On Order Qty | 0 | 360 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34824773 | Plan Receipt | 0 | 450 | 210 | 240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43552159 | On Order Qty | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43552159 | Plan Receipt | 0 | 10 | 40 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44916798 | On Order Qty | 0 | 10 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44916798 | Plan Receipt | 0 | 20 | 30 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50497228 | On Order Qty | 130 | 50 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50497228 | Plan Receipt | 130 | 220 | 330 | 290