Spreadsheet: 801515d1666240324-sum-based-on-label-column-criterias-sample-sum-based-on-header-column
Sheet: Production Allocation (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need formulas to sum based on label column criterias
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULT
PG | SAP Code | [NAME] | [NAME] | Total Qty PO Oct | 2022-09-29 00:00:00 |  | 2022-09-30 00:00:00 |  |  |  |  |  |  |  | 2022-10-01 00:00:00 |  |  |  |  |  |  |  | 2022-10-02 00:00:00 |  |  |  |  |  |  |  | 2022-10-03 00:00:00 |  |  |  |  |  |  |  | 2022-10-04 00:00:00 |  |  |  |  |  |  |  | 2022-10-05 00:00:00 |  |  |  |  |  |  |  | 2022-10-06 00:00:00 |  |  |  |  |  |  |  | 2022-10-07 00:00:00 |  |  |  |  |  |  |  | W1 Total |  |  |  |  |  |  |  |  |  | W1 Total
 |  |  |  |  |  |  | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock | Delivery |  |  |  |  |  | % | Remain Stock |  |  | Delivery |  |  |  | Prod Plan | Actual | % | Remain Stock
 |  |  |  |  | Prod Plan | Actual | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  | CWH | [NAME] | Branch WH | Dealer outside [NAME] | Prod Plan | Actual |  |  |  | BOH | CWH | [NAME] | Branch WH | Dealer outside [NAME]
BB | DH1U6B050 | [NAME] | ABCDE | 2000 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1RV1050 | [NAME] | ABCDE | 2300 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1U6A050 | [NAME] | ABCDE | 2600 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1SV2000 | LE40AQT6600FG | ABCDE | 1440 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1SV1000 | LE40AQT9200MF | ABCDE | 480 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1VY3050 | LE43AQT6700FG | ABCDE | 480 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1U91050 | LE50AQT6600UG | ABCDE | 240 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1SX1020 | LE58AQT6600UG | ABCDE | 480 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1U72043 | LE39AQTD6G | ABCDE | 475 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
BB | DH1W01010 | LE32F6000M | ABCDE | 1000 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YH5004 | AQR-D50F(S) | ABCDE | 250 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YH4004 | AQR-D50F(W) | ABCDE | 250 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHB008 | AQR-D181(LS) | ABCDE | 1700 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHA008 | AQR-D181(DS) | ABCDE | 12000 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHU007 | AQR-D261(LS) | ABCDE | 600 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BM03Z90AE | AQR-D261(LB) | ABCDE | 0 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BM03ZA0AE | AQR-D261(LK) | ABCDE | 0 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHS004 | AQR-D270(LS) | ABCDE | 200 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHU004 | AQR-D270(DS) | ABCDE | 3000 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BL05D0E00 | AQR-D270 (WDS) | ABCDE | 800 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BM04080AE | AQR-D270(LB) | ABCDE | 0 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BM04070AE | AQR-D270(LK) | ABCDE | 0 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHV004 | AQR-D275R (BK) | ABCDE | 2500 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BL05D2E8Z | AQR-D275R (WBK) | ABCDE | 900 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BL05D0EA7 | AQR-D275R(BD) | ABCDE | 400 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHC005 | AQF-S4(S) | ABCDE | 700 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YH7008 | AQF-S4(DS) | ABCDE | 900 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YHD005 | AQF-S6(S) | ABCDE | 900 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
CC | BK0YH9008 | AQF-S6(DS) | ABCDE | 1800 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | AABR55000 | AQA-KR5AHP | ABCDE | 2720 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | AABRS1000 | AQA-CR5AHP | ABCDE | 2720 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | AABR54000 | AQA-KR5AHP1 | ABCDE | 2720 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | AABRS2000 | AQA-CR5AHP1 | ABCDE | 2720 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | [NAME] | AQA-KR09AHP | ABCDE | 680 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | AAAG22007 | AQA-CR09AHP | ABCDE | 680 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | AABF1N000 | AQA-KR09AHP1 | ABCDE | 2720 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60
RAC | AAAG21007 | AQA-CR09AHP1 | ABCDE | 2720 | 700 | 600 | 100 | 50 | 30 | 80 |  |  |  |  | 100 | 50 | 30 | 60 | 700 | 500 |  |  | 100 | 50 | 30 | 60 | 600 | 600 |  |  | 100 | 50 | 30 | 60