Spreadsheet: 851015d1701282021-sumifs-multiple-criteria-sample-pr-excel
Sheet: Timesheet Data

PR # ST= stat | Row # | WORK Date | JOB CODE | FSA | SUB CODE 1 | SUB CODE 2 | SUB CODE 3 | WORK TYPE | FIRST NAME | LAST NAME | GL CODE | Unit 1 (Only use PERS for Oper Unit (Truck Rent)) | Unit2 | Unit3 | KM'S  (MOB,  A/R Billable) | KM's (EmpEE Rotation Travel) | HR1 - JOB 1  Field Hours | MOB-YARD HR1 CC15 | MOB MOVE HR1 CC17 | HR2 Shop Hours Misc Travel CC2010 | HR3  MOB Hours  Rotation Travel CC30 | HR4        DROP BONUS HRS | DROP    BONUS PIECES | UNPAID MOB Hours  Rotation Travel CC31 | ADJ Hours PR Corr | GRAND TOTAL HOURS | CELL BONUS - Y/N Once per PP | SUB | Full LOA | No LOA | Notes | HR1  REG FIELD HRS | HR1  REG FIELD RATE | HR2  REG SHOP HRS | HR2  REG SHOP RATE | HR3 ADJ TIME Rotation | HR3  ADJ RATE Rotation | OT HR1  REG OT HRS | OT HR1  FIELD RATE | [NAME] OT HRS | OT HR2  OT SHOP RATE | HR1,HR 2,HR3  TOTAL REG HOURS | OT HR1 + OT HR2  TOTAL OT HOURS | TOTAL HRS | TOTAL HRS-X-REF W/ COLUMN T = [NAME] | SUB | LOA - FULL | # OF TRUCK RENT | HR1  TOTAL WAGE | HR2  TOTAL WAGE | HR3  WAGE (Rotation) | OT HR1  TOTAL WAGE | [NAME] | STAT PAY | ADJ/PR Corr HRS * APPLICABLE RATE | PROD-BONUS DP1 | VACATION PAY | SUB * 58.00 | LOA-FULL * 130.00 | CELL BONUS 1 X PP @15.00 | TRUCK RENT *60.00
PR_1 WK_1 | 1 | 2023-01-02 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_1 | 2 | 2023-01-02 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_1 | 3 | 2023-01-02 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_1 | 4 | 2023-01-03 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_1 | 5 | 2023-01-03 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_1 | 6 | 2023-01-04 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_1 | 7 | 2023-01-05 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_1 | 8 | 2023-01-06 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_1 | 9 | 2023-01-07 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_1 | 10 | 2023-01-08 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_1 | 11 | 2023-01-09 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_1 | 12 | 2023-01-07 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_1 | 13 | 2023-01-11 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_1 | 14 | 2023-01-12 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_1 | 15 | 2023-01-13 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_1 | 16 | 2023-01-14 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_1 | 17 | 2023-01-15 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_1 | 18 | 2023-01-04 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_1 | 19 | 2023-01-05 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_1 | 20 | 2023-01-18 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_1 | 21 | 2023-01-19 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_2 | 22 | 2023-01-20 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_2 | 23 | 2023-01-21 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_2 | 24 | 2023-01-22 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_2 | 25 | 2023-01-23 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_2 | 26 | 2023-01-24 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_2 | 27 | 2023-01-25 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_2 | 28 | 2023-01-26 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_2 | 29 | 2023-01-27 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_2 | 30 | 2023-01-28 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_2 | 31 | 2023-01-29 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_2 | 32 | 2023-01-30 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_2 | 33 | 2023-01-31 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18
PR_1 WK_2 | 34 | 2023-01-29 00:00:00 | 597 |  | 1165 |  |  | ADMN | MELISSA | APPLE |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Y |  |  | 1 |  |  | 22 |  | 20
PR_1 WK_2 | 35 | 2023-01-15 00:00:00 | 592 |  | 2010 | 10 |  | MGMT | [NAME] | PIE |  | ML |  |  |  |  | 3 |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 |  |  | 40 |  | 35
PR_1 WK_2 | 36 | 2023-01-31 00:00:00 | 799 |  | 2010 |  |  | OPH | EMMA | ORANGE |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 1 |  |  | 18 |  | 18