Spreadsheet: 42048d1240589533-sumproduct-not-working-due-to-text-in-column-test-planners-2
Sheet: Sheet01

Test Client
CLIENT | Test Client | WORKSITE | [NAME]
MRF | 12345 | ACCESS @ | Piccadilly Station
REQUESTER | [NAME] | DEPOT | [NAME]
QS | [NAME] | WORK DETAILS | Re-Rail
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
Sat 2300 - Sun 1100 | ES | [NAME] | [NAME] | 30 | 35 | LTD | OT2 | 12 | 360 | 420
 | COSS | [NAME] | [NAME] | 20 | 25 | LTD | OT2 | 12 | 240 | 300
 | LXA | [NAME] | [NAME] | 15 | 20 | LTD | OT2 | 12 | 180 | 240
 | LXA | [NAME] | [NAME] | 15 | 20 | LTD | OT2 | 12 | 180 | 240
 | SITE CONTACT: | [NAME] | [NAME]
CLIENT | Test Client | WORKSITE | [NAME]
MRF | 12346 | ACCESS @ | Piccadilly Station
REQUESTER | [NAME] | DEPOT | [NAME]
QS | [NAME] | WORK DETAILS | Re-Rail
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
Sat 2300 - Sun 1100 | TM | [NAME] | [NAME] | 8 | 12 | LTD | OT2 | 12 | 96 | 144
 | TM | [NAME] | [NAME] | 8 | 12 | LTD | OT2 | 12 | 96 | 144
 | TM | [NAME] | [NAME] | 8 | 12 | LTD | OT2 | 12 | 96 | 144
 | TM | [NAME] | [NAME] | 8 | 12 | LTD | OT2 | 12 | 96 | 144
 | TM | [NAME] | [NAME] | 8 | 12 | LTD | OT2 | 12 | 96 | 144
 | TM | [NAME] | [NAME] | 8 | 12 | LTD | OT2 | 12 | 96 | 144
 | SITE CONTACT: | [NAME] | [NAME]
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | Test Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT: