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

 | 0
CLIENT | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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: