Spreadsheet: 169602d1342976692-create-a-formula-to-add-cells-in-one-column-if-it-meets-the-criteria-for-another-column-suzys-hourly-employee-worksheet
Sheet: Hourly Field Worksheet

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
Employee List |  |  |  |  |  |  |  |  |  |  |  | Job List |  |  |  |  | Hourly Timesheets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Regular, OT & Vacation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start Date: | 2012-07-02 00:00:00 | Timesheet Data Input |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Job Costing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Job Costing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Job Cost Dollar Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subtotal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subtotal |  |  | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee | Job # |  |  |  |  |  |  |  | Subtotal Week 1 |  |  |  |  |  |  |  | Subtotal Week 2 |  | Grand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 2 |  |  | Weeks 1 & 2
Employee Key | Last Name | First Name | Emp # | Rate | Vac Hours Request | Vac Days Request | Vac Dollars Request | Overtime Rate | Vacation Rate | Vacation Payout |  | Job | Company | Job # | Company Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT | Reg | OT |  | Reg | OT
 | Smith | [NAME] | 101 | 20 |  |  |  |  |  |  |  |  | Norag 1 | 1000 | Company A |  | Smith, [NAME] (101) | A-1000 | 3 |  |  |  | 1 |  |  |  |  | 4 |  |  |  | 8 | 8
 | MacDonald | [NAME] | 102 | 21 |  |  |  |  |  |  |  |  | Norag 2 | 1001 | Company B |  | MacDonald, [NAME] (102) | B-1001 |  | 4 |  |  |  | 0.5 |  |  |  |  |  |  |  | 1.5 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  | Norag 3 | 1002 | Company C |  | Smith, [NAME] (101) | C-1002 |  |  | 2 |  | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Norag 4 | 1003 | Company D |  | MacDonald, [NAME] (102) | [NAME] |  |  |  | 3 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Norag 5 | 1004 | Company E |  | Smith, [NAME] (101) | E-1004 | 4 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | A-1000 |  | 2 |  |  |  | 0.5 | 2 |  |  | 4 | 8 | 8 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | B-1001 |  |  | 3 |  | 1 |  |  |  |  | 8.5 | 0.5 | 2.5 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | C-1002 |  |  |  | 2 |  | 1 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | [NAME] | 2 |  |  |  | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | E-1004 |  | 3 |  |  |  | 0.5 |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | A-1000 |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | B-1001 |  |  |  | 4 |  | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | C-1002 | 3 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | [NAME] |  | 5 |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | E-1004 |  |  | 2 |  | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | A-1000 | 3 |  |  |  | 1 |  |  |  |  | 4 |  |  |  | 8 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | B-1001 |  | 4 |  |  |  | 0.5 |  |  |  |  |  |  |  | 1.5 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | C-1002 |  |  | 2 |  | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | [NAME] |  |  |  | 3 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | E-1004 | 4 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | A-1000 |  | 2 |  |  |  | 0.5 | 2 |  |  | 4 | 8 | 8 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | B-1001 |  |  | 3 |  | 1 |  |  |  |  | 8.5 | 0.5 | 2.5 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | C-1002 |  |  |  | 2 |  | 1 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | [NAME] | 2 |  |  |  | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | E-1004 |  | 3 |  |  |  | 0.5 |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | A-1000 |  |  | 2 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | B-1001 |  |  |  | 4 |  | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | C-1002 | 3 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smith, [NAME] (101) | [NAME] |  | 5 |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MacDonald, [NAME] (102) | E-1004 |  |  | 2 |  | 1 |  | 2