Spreadsheet: 76375d1276876637-sumproduct-across-multiple-sheets-not-working-service-dispatch-w-tabs
Sheet: INTERNALS

Status | A Customer | S.A. | RO | Model | Promised | A-Tech | Hours | Dispatched At | Completed At | Job Description |  |  |  |  | Reason for Hold
ASSIGNED | INTERNAL | 11912 | 65678 | 10 XL1200X | ASAP | TF | 27.85 | 4/14/20104:36 PM |  | INST ACCYS
ASSIGNED | INTERNAL / KAEHLER / SCHNEIDER | 11856 | 66067 | 10 FLHTCU | 6/15 @ 12 | RAS | 0.5 | 6/14/20102:28 PM |  | INSTALL ACCYS
ASSIGNED | INTERNAL | AK | 66450 | 07 FLHX | 2010-05-24 00:00:00 | AC | 1.5 | 5/27/201010:13 AM |  | PERFORM UVD/ 15 POINT INSPECTION
ASSIGNED | INTERNAL | 11914 | 66541 | 10 FXDWG | 2010-05-27 00:00:00 | RAS | 4 | 5/27/20108:52 AM |  | IK SERVICE
ASSIGNED | INTERNAL MAJOR UNIT | 11965 | 66555 | 10 FXD | 2010-05-27 00:00:00 | MK | 0.75 | 6/3/201010:41 AM |  | DEALER TRADE
ASSIGNED | INTERNAL | 11928 | 66576 | 98 FLSTC | 2010-05-28 00:00:00 | DAN | 1.4 | 6/16/20101:32 PM |  | INSTALL ACCESSORIES
ASSIGNED | INTERNAL MAJOR UNIT | 11924A | 66623 | 03 FLSTF | 2010-06-01 00:00:00 | RS | 1.5 | 6/2/20103:53 PM |  | PERFORM UVD/15-PT INSPECTION, PERFORM RECALL 0119
ASSIGNED | INTERNAL MAJOR UNIT | 11975 | 66788 | 85 FLHS | 2010-06-08 00:00:00 | RS | 1.5 | 6/9/20104:23 PM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL MAJOR UNIT | 11464 | 66813 | 09 VRSCF | 2010-06-09 00:00:00 | MH | 5.9 | 6/9/20101:53 PM |  | INSTALL ACCESSORIES
ASSIGNED | INTERNAL | 11986 | 66868 | 05 XL1200C | 2010-06-11 00:00:00 | AC | 1.5 | 6/14/20108:05 AM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11985 | 66873 | 05 FXDC | 2010-06-11 00:00:00 | RS | 1.5 | 6/15/201012:59 PM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11984 | 66875 | 02 FLSTCI | 2010-06-11 00:00:00 | MH | 1.5 | 6/15/201010:26 AM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11195A1 | 66903 | 01 FLHTCI | 2010-06-14 00:00:00 | MK | 1.5 | 6/16/20109:24 AM |  | UVD/15-PT INSPECTION
HOLD - NO BIKE | INTERNAL / LENZEN | 11869 | 65844 | 10 FLHTK | 2010-05-14 00:00:00 | JZ | 15.05 | 5/10/201010:17 AM |  | INST ACCYS/ DYNO TIME
HOLD - WAITING TO TALK TO AMY | INTERNAL | 11972 | 66693 | 04 FLSTFI | 2010-06-03 00:00:00 | RS | 1.5 | 6/8/201012:03 PM |  | PERFORM UVD/15-PT INSPECTION
NEEDS DYNO | INTERNAL | 11924 | 66479 | 10 FLHX | 2010-06-10 00:00:00 | AC | 6.95 | 6/9/201010:44 AM
 | SALES | 11771A | 66635 |  | 2010-06-11 00:00:00 |  | 1.5 |  |  | PERFORM UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11910A | 66941 | 90 FLHTCUI |  | MH | 1.5 | 6/17/20108:03 AM |  | PERFORM UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11810B | 66944 | 95 XL1200 |  | MH | 1.5 | 6/17/20101:32 PM |  | PERFORM UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | Z401A | 66943 | 01 FLHTCU |  | MH | 1.5 | 6/17/201011:52 AM |  | PERFORM UVD/15-PT INSPECTION
[NAME] | INTERNAL/ DENNIK | Z403 | 66942 | 09 FXR REP |  | MH | 1 | 6/17/201011:09 AM | 6/18/20108:09 AM | PERFORM UVD/15-PT INSPECTION
[NAME] | INTERNAL | 11936B | 66946 | 00 XL883H |  | MK | 1.5 | 6/17/201010:06 AM | 6/18/201010:35 AM | PERFORM UVD/15-PT INSPECTION
[NAME] | INTERNAL/ DIAZ | 11296 | 66656 | 09 FXDB |  | RA | 6.4 |  | 6/18/20109:54 AM | INST ACCYS
[NAME] | INTERNAL | 11994 | 66975 | 10 FLHRC | ASAP | MH | 0.75 | 6/17/20104:11 PM | 6/18/201010:35 AM | DEALER TRADE