Spreadsheet: 774975d1648745733-total-based-on-3-criteria-items-need-a-formula-excel-forum-sample-1
Sheet: Hourly

Department | Branch Code | Job | Regular Hours | Regular Earnings | OT Hours | OT Earnings | DT Hours | [NAME] | CMP Hours | [NAME] | Vacation Hours | Vacation Earnings | Sick Hours | [NAME] | Float Hours | Float Earnings | Bereavement Hours | [NAME] | Bonus | Care Differential Hours | Care Differential Earnings | HOLIDAY HOURS
[NAME] | 2106 | Sorter | 17.783 | 276.367 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 2109 | Sorter | 12.9 | 188.517 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3218 | Sorter | 4.266 | 68.266 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interregional Sort | 3218 | Sorter | 212.149 | 4042.174 | 10.434 | 315.276 | 0 | 0 | 2 | 43.518 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interregional Sort | 3218 | [NAME] | 16 | 332 | 3.9 | 120.513 | 0 | 0 | 1 | 20.174 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3218 | Sorter | 114.517 | 2281.583 | 17.284 | 520.4169999999999 | 0 | 0 | 3 | 66.073 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3218 | Sorter | 169.2679999999999 | 3369.158 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3218 | [NAME] | 18.867 | 464.412 | 0.2 | 7.98 | 0 | 0 | 1 | 27.008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3314 | Sorter | 5.949999999999999 | 113.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 288 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3314 | [NAME] | 8 | 184.313 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3320 | Sorter | 821.8829999999998 | 13609.01 | 4.401 | 115.013 | 0 | 0 | 4 | 64.5 | 6 | 114 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3320 | [NAME] | 31.75 | 588.103 | 1.367 | 36.285 | 0 | 0 | 0 | 0 | 8 | 140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interregional Sort | 3320 | Sorter | 358.082 | 6007.791000000001 | 0 | 0 | 0 | 0 | 2 | 35.929 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interregional Sort | 3320 | [NAME] | 23.417 | 425.02 | 0.15 | 4.154 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3320 | Sorter | 11.883 | 190.133 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3320 | Sorter | 9.95 | 167.225 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3320 | [NAME] | 8 | 149.521 | 0.517 | 14.485 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3320 | [NAME] | 48.534 | 961.37 | 0 | 0 | 0 | 0 | 1 | 21.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PM Sort | 3321 | Sorter | 6.116 | 103.984 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3324 | Sorter | 328.1629999999999 | 5722.240999999999 | 0.683 | 17.95 | 0 | 0 | 5 | 85.392 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3324 | [NAME] | 23.534 | 447.134 | 0.633 | 17.85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interregional Sort | 3324 | Sorter | 8 | 152 | 0.117 | 3.325 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3324 | Sorter | 6.266999999999999 | 106.533 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3324 | Sorter | 72.28600000000002 | 1260.907000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3324 | [NAME] | 21.9 | 431.4299999999999 | 0.233 | 6.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3324 | [NAME] | 9.6 | 199.896 | 0 | 0 | 0 | 0 | 1 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3420 | Sorter | 95.832 | 1771.725000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3420 | Sorter | 501.8 | 9390.821000000005 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 18.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3420 | [NAME] | 25.1 | 538.265 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3420 | [NAME] | 23.501 | 491.809 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3513 | Sorter | 103.531 | 1485.269 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3513 | Sorter | 103.65 | 1489.391 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3513 | [NAME] | 8.567 | 137.067 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3513 | [NAME] | 15.05 | 248.325 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PM Sort | 3655 | Sorter | 107.717 | 1642.858 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PM Sort | 3655 | [NAME] | 5.883 | 110.136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3655 | Sorter | 3.767 | 56.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3703 | Sorter | 253.233 | 3930.709 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Day Sort | 3703 | [NAME] | 19.217 | 357.048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Twilight Sort | 3703 | Sorter | 166.016 | 2550.292 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3703 | [NAME] | 23.6 | 359.933 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PM Sort | 3730 | [NAME] | 3.117 | 62.676 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3730 | [NAME] | 4.65 | 94.163 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PM Sort | 3810 | Sorter | 27.833 | 496.184 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3810 | Sorter | 259.5170000000001 | 4651.216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3810 | [NAME] | 30.184 | 613.7500000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3810 | [NAME] | 12.333 | 246.667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PM Sort | 3910 | Sorter | 46.166 | 885.542 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 3910 | Sorter | 13.166 | 237 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yard | 3910 | [NAME] in Training | 3.917 | 90.083 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Totals