Spreadsheet: 783306d1654716061-sumif-1-vertical-column-and-across-multiple-horizontal-match-practice-for-excel-forum
Sheet: InstallBase

 |  |  |  | BMD | BMD | BMD | BMD
ATM | Model | Hub | Team | 7430003725 | 7430007761 | 7430002575 | 7430002573
7221000385 | MX5300SE:4K:F/K:L-1:EMV:US | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7221000463 | SYSTEM:MX5600:HCDU_5CST:Q87:PNC:US | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7221000482 | SYSTEM:MX5200SE:4K:EMV:LEV1:US:TYPE2_KR | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7223000200 | SYSTEM:MX7800I:W_CCIM2.5:CEN-L | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7223000202 | MX7800T:W_CCIM30:CEN-1:BAC | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7223000205 | #N/A | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7223000206 | MX7600I:HCDU_4:W/O_CCIM:H81:FI:US | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7223000258 | MX7800IA:W_CCIM32:CEN-1:BAC | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7223000260 | SYSTEM:MX7800TR:CCIM16:BRM60:L-1:CHASE | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 0
7223000274 | SYSTEM:MX7800IR:W_CCIM16:W_BRM60:CHASE | DFWSUB010 | OK-Tulsa | 0 | 7 | 0 | 0
7224000109 | MX8700QT:CHASE | DFWSUB010 | OK-Tulsa | 0 | 0 | 0 | 2
7224000146 | MX8200QT:eATM3.0:INTEGRATED:CHASE | DFWSUB010 | OK-Tulsa | 0 | 0 | 2 | 0
7224000192 | MX8200QT:INTEGRATED:Q87 CE:CHASE | DFWSUB010 | OK-Tulsa | 0 | 0 | 5 | 0
7250000154 | MS500:US_CHASE | DFWSUB010 | OK-Tulsa | 2 | 0 | 0 | 0
7221000261 | MX5200_4K_EMV_E-LocK | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7221000344 | MX5300SE:4K:F/K:BIZ:EMV:US | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7221000393 | MX5100T:H81:10.1"_SPL:L-1:E-LOCK | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7221000463 | SYSTEM:MX5600:HCDU_5CST:Q87:PNC:US | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7221000482 | SYSTEM:MX5200SE:4K:EMV:LEV1:US:TYPE2_KR | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7221000484 | SYSTEM:MX5300SE:4K:F/K:L-1:EMV:US_KR | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7223000066 | MX7600I | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7223000184 | MX7800I:W_CCIM2.5:BAC | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7223000247 | MX7800IA:Q87:CCIM30:CEN1:BOA | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7223000254 | MX7800:W_CCIM32:CEN-1:BAC | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7223000256 | MX7800D:W_CCIM32:CEN-1:BAC | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7223000274 | SYSTEM:MX7800IR:W_CCIM16:W_BRM60:CHASE | DFWSUB019 | OK-Oklahoma City | 0 | 17 | 0 | 0
7224000109 | MX8700QT:CHASE | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 6
7224000143 | 8200QT V3.0 | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 1 | 0
7224000192 | MX8200QT:INTEGRATED:Q87 CE:CHASE | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 9 | 0
7224000339 | MX8100T:8.5"_10"_13"SLEEVE:CHASE | DFWSUB019 | OK-Oklahoma City | 0 | 0 | 0 | 0
7250000154 | MS500:US_CHASE | DFWSUB019 | OK-Oklahoma City | 4 | 0 | 0 | 0
7221000074 | SYSTEM:MX5621L:CDU10:USA:CHASEBANK | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 0
7221000239 | MX5600:CDU10:CHASE:W/O CENCON | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 0
7221000393 | MX5100T:H81:10.1"_SPL:L-1:E-LOCK | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 0
7223000193 | MX7800I:W_CCIM2.0:Q87:CHASE | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 0
7223000260 | SYSTEM:MX7800TR:CCIM16:BRM60:L-1:CHASE | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 0
7223000274 | SYSTEM:MX7800IR:W_CCIM16:W_BRM60:CHASE | ORDSUB001 | Central IL-Bloomington | 0 | 6 | 0 | 0
7224000085 | MX8800:HYBRID ATM:PNC BANK | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 2
7224000146 | MX8200QT:eATM3.0:INTEGRATED:CHASE | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 2 | 0
7224000184 | SYSTEM:MX8200TA:US:CHASE:10:ADAPTOR:ADA | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 1
7224000192 | MX8200QT:INTEGRATED:Q87 CE:CHASE | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 5 | 0
7224000277 | MX8100QTN:15"OPL_L-1:CHASE | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 0
7228000205 | 2600HALOII-4K-E-EMV-US | ORDSUB001 | Central IL-Bloomington | 0 | 0 | 0 | 0
7250000154 | MS500:US_CHASE | ORDSUB001 | Central IL-Bloomington | 1 | 0 | 0 | 0
7221000197 | MX5100T:E-LOCK:LEVEL-1:SANKYO | ORDSUB004 | Central IL-Springfield | 0 | 0 | 0 | 0
7221000239 | MX5600:CDU10:CHASE:W/O CENCON | ORDSUB004 | Central IL-Springfield | 0 | 0 | 0 | 0
7223000274 | SYSTEM:MX7800IR:W_CCIM16:W_BRM60:CHASE | ORDSUB004 | Central IL-Springfield | 0 | 2 | 0 | 0
7224000146 | MX8200QT:eATM3.0:INTEGRATED:CHASE | ORDSUB004 | Central IL-Springfield | 0 | 0 | 1 | 0
7224000192 | MX8200QT:INTEGRATED:Q87 CE:CHASE | ORDSUB004 | Central IL-Springfield | 0 | 0 | 4 | 0
7250000154 | MS500:US_CHASE | ORDSUB004 | Central IL-Springfield | 1 | 0 | 0 | 0
7221000197 | MX5100T:E-LOCK:LEVEL-1:SANKYO | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7221000239 | MX5600:CDU10:CHASE:W/O CENCON | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7221000371 | MX5300S:Q87:8K:TS:BIZ:ANTI-S:FCTI | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7221000393 | MX5100T:H81:10.1"_SPL:L-1:E-LOCK | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7221000482 | SYSTEM:MX5200SE:4K:EMV:LEV1:US:TYPE2_KR | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7221000484 | SYSTEM:MX5300SE:4K:F/K:L-1:EMV:US_KR | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000184 | MX7800I:W_CCIM2.5:BAC | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000199 | MX7800T:W_CCIM2.5:BAC | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000200 | SYSTEM:MX7800I:W_CCIM2.5:CEN-L | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000201 | MX7800:W_CCIM30:CEN-1:BAC | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000202 | MX7800T:W_CCIM30:CEN-1:BAC | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000204 | MX7600I:HCDU_2:W/O_CCIM:H81:FI:US | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000206 | MX7600I:HCDU_4:W/O_CCIM:H81:FI:US | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000229 | MX7600DA:H81:W/O_CCIM:2CST:10":FI | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000247 | MX7800IA:Q87:CCIM30:CEN1:BOA | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000249 | MX7800D:W_CCIM30:[NAME]:FI | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000250 | MX7800T:W_CCIM30:[NAME]:FI | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000255 | MX7800T:W_CCIM32:CEN-1:BAC | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000258 | MX7800IA:W_CCIM32:CEN-1:BAC | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000260 | SYSTEM:MX7800TR:CCIM16:BRM60:L-1:CHASE | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000270 | SYSTEM:MX7800DR:CCIM15:BRM60:L-1:CHASE | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 0
7223000274 | SYSTEM:MX7800IR:W_CCIM16:W_BRM60:CHASE | ORDSUB005 | MO-Saint Louis | 0 | 31 | 0 | 0
7224000085 | MX8800:HYBRID ATM:PNC BANK | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 1
7224000192 | MX8200QT:INTEGRATED:Q87 CE:CHASE | ORDSUB005 | MO-Saint Louis | 0 | 0 | 33 | 0
7224000262 | MX8800:DIP_ANTI:US:Q87 | ORDSUB005 | MO-Saint Louis | 0 | 0 | 0 | 2
7250000154 | MS500:US_CHASE | ORDSUB005 | MO-Saint Louis | 1 | 0 | 0 | 0
7250000184 | MS500:US_Standard | ORDSUB005 | MO-Saint Louis | 24 | 0 | 0 | 0
7221000205 | 5312L:S:M3(3C):DIAL:ND:K1:EMV:US | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7221000344 | MX5300SE:4K:F/K:BIZ:EMV:US | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7221000371 | MX5300S:Q87:8K:TS:BIZ:ANTI-S:FCTI | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7221000385 | MX5300SE:4K:F/K:L-1:EMV:US | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7221000393 | MX5100T:H81:10.1"_SPL:L-1:E-LOCK | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7221000441 | SYSTEM:MX5600:HCDU_2CST:H81:T/S:FI:US | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7221000482 | SYSTEM:MX5200SE:4K:EMV:LEV1:US:TYPE2_KR | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7221000484 | SYSTEM:MX5300SE:4K:F/K:L-1:EMV:US_KR | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000184 | MX7800I:W_CCIM2.5:BAC | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000198 | MX7800:W_CCIM2.5:BAC | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000199 | MX7800T:W_CCIM2.5:BAC | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000200 | SYSTEM:MX7800I:W_CCIM2.5:CEN-L | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000201 | MX7800:W_CCIM30:CEN-1:BAC | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000202 | MX7800T:W_CCIM30:CEN-1:BAC | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000204 | MX7600I:HCDU_2:W/O_CCIM:H81:FI:US | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000206 | MX7600I:HCDU_4:W/O_CCIM:H81:FI:US | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000221 | MX7600TA:H81:W/O_CCIM:2CST:10":FI | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000229 | MX7600DA:H81:W/O_CCIM:2CST:10":FI | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000247 | MX7800IA:Q87:CCIM30:CEN1:BOA | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000255 | MX7800T:W_CCIM32:CEN-1:BAC | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000258 | MX7800IA:W_CCIM32:CEN-1:BAC | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000260 | SYSTEM:MX7800TR:CCIM16:BRM60:L-1:CHASE | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000268 | SYSTEM:MX7800I:W_CCIM2.0:STD | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000274 | SYSTEM:MX7800IR:W_CCIM16:W_BRM60:CHASE | ORDSUB022 | MO-Kansas City | 0 | 27 | 0 | 0
7223000324 | MONIMAX 7800T | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7223000325 | SYSTEM:MX7800D:CCIM30:CEN1:DIP_AS:HYB:FI | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7224000085 | MX8800:HYBRID ATM:PNC BANK | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 2
7224000192 | MX8200QT:INTEGRATED:Q87 CE:CHASE | ORDSUB022 | MO-Kansas City | 0 | 0 | 19 | 0
7224000256 | MX8200QTN:4RC:BOA | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7224000262 | MX8800:DIP_ANTI:US:Q87 | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 1
7224000277 | MX8100QTN:15"OPL_L-1:CHASE | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7224000378 | SYSTEM:MX8100QTN:15"OPL_L-1:DARK GRAY:CT | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0
7250000184 | MS500:US_Standard | ORDSUB022 | MO-Kansas City | 2 | 0 | 0 | 0
MX5200 Dua | #N/A | ORDSUB022 | MO-Kansas City | 0 | 0 | 0 | 0