Spreadsheet: 104510d1302101034-summing-multiple-columns-based-on-criteria-standardoverdoubletime
Sheet: MARCH

 |  |  |  |  | NON 10 REVENUE JOBS
DATE:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Machinist Cost
COMPANY NAME |  | [NAME] | [NAME] | MACHINIST | ST, OT, DT | Q & A | ST, OT, DT | P & F | ST, OT, DT | SHIP / REC | ST, OT, DT | [NAME] | ST, OT, DT | GAUGE | FREIGHT | 1 | 0
 |  | NUMBER | NUMBER | HOURS | S, O, D | HOURS | S, O, D | HOURS | S,O, D | HOURS | S, O, D | HOURS | S, O, D | RENTAL |  | 2 | 0
 | 1 | 744982 | 285119 | 6.34 | S | 2.48 | O | 1.57 | O |  |  |  |  |  |  |  | 0
 | 1 | 746642 | 288660 |  |  | 5.15 | O
 | 2 | 746816 | 288847 | 2.65 | S | 0.8 | S | 2.54 | O |  |  |  |  | 67.77
 | 2 | 746816 | 288847 |  |  | 0.57 | O
 | 1 | 746914 | 289065 |  |  | 0.85 | O | 3.19 | O
 | 1 | 746914 | 289067 |  |  | 0.85 | O | 1.07 | O
 | 1 | 746914 | 289068 |  |  | 0.85 | O | 1.07 | O
 | 1 | 747073 | 289433 | 3.8 | S | 1.4 | S | 1.63 | O |  |  |  |  | 128.25 | 25.18
 | 1 | 747073 | 298434 | 2.85 | S | 1.08 | O |  |  |  |  |  |  | 186.88 | 52.07
 | 1 | 747073 | 289434 |  | S | 1.66 | S
 | 1 | 747073 | 289435 | 2.54 | S | 1.63 | S |  |  |  |  |  |  | 186.88 | 52.07
 | 1 | 747073 | 289435 |  |  | 1.07 | O
 | 1 | 747342 | 290189 |  |  |  |  |  |  |  |  | 4.2 | O
 | 1 | 747534 | 290672 | 13.55 | S | 0.48 | S |  |  |  |  | 11.09 | S
 | 2 | 747576 | 290743 | 2.26 | S | 1.81 | S | 0.92 | O |  |  |  |  | 150 | 89.36
 | 2 | 747576 | 290743 |  |  | 2.73 | O
 | 2 | 747869 | 291578 | 2.55 | S | 1.94 | S |  |  |  |  |  |  | 536 | 54.89
 | 2 | 747869 | 292579 |  |  | 2.93 | S | 1.17 | O
 | 2 | 747907 | 291651 |  |  | 0.23 |  |  |  |  |  | 0.76 | S
 | 2 | 747907 | 291652 |  |  | 0.23 | S |  |  |  |  | 0.72
 | 1 | 748082 | 291962 | 1.02 | O | 0.17 | S
 | 1 | 748082 | 291962 |  |  | 2.51 | O
 | 1 | 748349 | 292541 |  |  | 2.82 | O |  |  |  |  | 0.85 | S
 | 4 | 748620 | 293213 |  |  |  |  | 1.9 | S
 | 1 | 748634 | 293237 | 1.61 | S | 0.89 | O | 1.75 | D |  |  |  |  | 4.7
 | 1 | 748634 | 293237 | 0.32 | O | 0.32 | D
 | 1 | 748082 | 291963 | 1.24 | O | 0.17 | S
 | 1 | 748082 | 291963 |  |  | 2.55 | O
 | 1 | 748588 | 293136 |  |  |  |  |  |  |  |  | 0.99 | S
 | 2 | 747907 | 291655 | 2 | S | 2.8 | S
 | 2 | 748057 | 291930 | 1.14 | S | 1.14 | S |  |  |  |  |  |  | 79.2
 | 2 | 748003 | 291857 | 1.52 | S | 3.52 | S |  |  |  |  |  |  | 117.13
 | 2 | 748003 | 291857 |  |  | 1.28 | O | 2.58 | O
 | 2 | 748003 | 271858 | 1.39 | S | 0.7 | S | 1.75 | D |  |  |  |  | 47.16
 | 2 | 748003 | 271859 | 2.43 | O | 0.69 | S
 | 2 | 747786 | 291095 | 1.05 | S | 0.66 | O | 0.2 | O |  |  |  |  | 23.58
 | 2 | 746813 | 288832 | 2.26 | S | 3.31 | S |  |  |  |  |  |  | 287.12
 | 2 | 747893 | 291618 | 4.63 | S | 1.4 | S | 4.97 | O |  |  |  |  | 239.27
 | 2 | 747893 | 291618 |  |  | 2.27 | O
 | 2 | 747893 | 291619 |  |  | 2.25 | O | 4.95 | O
 | 2 | 747893 | 291619 |  |  | 1.4 | S
 | 2 | 747724 | 290932 | 6.07 | S | 4.94 | S | 7.02 | D |  |  |  |  | 295.43
 | 2 | 748055 | 291926 | 3.59 | S | 0.45 | S | 4.56 | O |  |  |  |  | 604.65
 | 2 | 748055 | 291926 | 11.14 | O | 4.27
 | 2 | 747796 | 291444 | 2.45 | S | 2.08 | S | 3.33 | S
 | 2 | 748122 | 292069 |  |  | 4.55 | S
 | 2 | 748122 | 292069 |  |  | 3.07 | O | 1.65 | O
 | 2 | 748122 | 292072 | 4.6 | O | 1.46 | O
 | 2 | 748122 | 292073 | 1.58 | S | 1.1
 | 2 | 748402 | 292667 |  |  | 0.22 | D
 | 2 | 748402 | 292668 |  |  |  |  | 24.19 | D
 | 2 | 748402 | 292669 |  |  | 0.1 | D
 | 2 | 748138 | 292122 | 1.9 | S | 1.03 | S |  |  |  |  |  |  | 66.29
 | 2 | 748138 | 292122 |  |  | 1.78 | O
 | 2 | 748138 | 292123 | 2.17 | S |  |  |  |  |  |  |  |  | 268 | 80.36
 | 1 | 746642 | 288660 |  |  |  |  | 5.15 | O
 | 1 | 745894 | 286892 |  |  | 1.14 | O | 1.25 | O
 | 1 | 746944 | 289120 | 2.22 | S | 0.06 | S |  |  |  |  | 1.17 | S
 | 1 | 747534 | 290672 | 13.55 | S | 0.48 | S |  |  |  |  | 11.09
 | 1 | 747595 | 290781 | 1.05 | S | 1.74 | S
 | 1 | 746605 | 288331 | 2.13 | S | 0.06 | S |  |  |  |  | 1.23 | S
 | 1 | S16-11-089 | 288920 |  |  |  |  |  |  |  |  | 2.3 | S
 | 1 | 746933 | 289098 | 1.74 | S | 0.06 | S |  |  |  |  | 1.27 | S
 | 1 | 746948 | 289124 | 4.07 | S | 0.07 | S |  |  |  |  | 1.15 | S
 | 1 | S16-11-316 | 290577 |  |  |  |  |  |  |  |  | 3.53 | S
 | 1 | 746914 | 289067 |  |  | 0.85 | O | 1.07 | O
 | 2 | 746816 | 288847 | 2.65 | S | 0.8 | S | 2.54 | S
 | 2 | 746816 | 288847 |  |  | 0.57 | O
 | 2 | 748428 | 292752 | 1.65 | S | 0.73 | S | 1.97 | S |  |  |  |  | 38.06
 | 2 | 747356 | 290261 |  |  | 0.27 | S
 | 1 | 745853 | 286836 | 5.4 | O | 1.04 | S |  |  |  |  | 3.87 | S
 | 1 | 745853 | 286837 | 3.58 | O | 1.95 | S | 2.2 | D |  |  | 4.13 | S
 | 2 | 748305 | 292435 | 2.08 | S | 1.85 | S | 3.67 | O |  |  |  |  | 371 | 93.06
 | 2 | 748305 | 292435 |  |  | 0.45 | O
 | 2 | 748305 | 292436 | 2.8 | S | 0.6 | S |  |  |  |  |  |  | 371 | 93.06
 | 2 | 748305 | 292436 |  |  | 0.99 | D
 | 2 | 748439 | 292799 | 3.55 | S | 2.36 | S |  |  |  |  |  |  | 29.42 | 24.4
 | 2 | 748439 | 292799 |  |  | 1.54 | D
 | 2 | 748902 | 293764 | 4.54 | S | 4.11 | S | 2.67 | S
 | 2 | 748943 | 293846 | 1.48 | S | 0.65 | S
 | 2 | 748460 | 292851 |  |  |  |  |  |  |  |  | 3.3 | S
 | 1 | 748584 | 293132 | 2.28 | S | 0.54 | S | 0.94 | S
 | 1 | 748584 | 293132 |  |  | 0.58 | O
 | 2 | 748611 | 293191 | 2.94 | S | 6.52 | S | 3.89 | S |  |  |  |  | 36.2
 | 2 | 748835 | 293616 | 4.67 | S
 | 2 | 748769 | 293464 | 0.66 | S | 0.23 | S | 0.1 | S
 | 2 | 748769 | 293464 | 1.45 | O
 | 2 | 748486 | 292928 | 2.13 | S | 0.56 | S |  |  |  |  |  |  | 18.1
 | 2 | 748486 | 292929 | 4.53 | S | 1.23 |  |  |  |  |  |  |  | 18.1
 | 2 | 748670 | 293297 | 2.3 | S | 1.94 | S | 1.02 | S |  |  |  |  | 21.91
 | 2 | 748670 | 293298 | 0.17 | O | 4.94 | S |  |  |  |  |  |  | 46.77 | 15.27
 | 2 | 748668 | 293292 | 4.27 | O | 0.94 | S | 1.02 | O |  |  |  |  | 43.83
 | 2 | 748668 | 293296 | 2.01 | O | 0.92 | S | 1.61 | S |  |  |  |  | 93.53 | 15.27
 | 2 | 748485 | 292922 | 0.45 | S | 0.75 | S |  |  |  |  |  |  | 76.3
 | 2 | 748485 | 292922 | 1.85 | O | 2.75 | O
 | 1 | 748349 | 292541 |  |  | 2.82 | O |  |  |  |  | 0.85 | S
 | 2 | 746833 | 288893 | 2.85 | S | 1.67 | O |  |  |  |  |  |  | 40.25 | 13.46 | S
 | 2 | 746833 | 288894 | 1.07 | S | 1.53 | O | 3.08 | S |  |  |  |  | 40.25 | 13.46 | O
 | 2 | 747636 | 290846 | 2.93 | S | 2.78 | S |  |  |  |  |  |  | 55.96 |  | D
 | 2 | 747283 | 289990 | 1.25 | S | 0.41 | S | 0.5 | S |  |  |  |  | 84 | 35.54
 |  | Machinist Hours |  | Q & A Hours |  | P & F Hours |  | Ship/Rec Hours |  | I.D. Hours | TOTALS |  |  | TOTAL    RENTAL | TOTAL    FREIGHT
Capital | 1 | 69.29 |  | 38.32 |  | 20.89 |  | 0 |  | 47.72 | 176.22 |  |  | 506.71 | 129.32
Lafayette | 2 | 111.66 |  | 99.80000000000001 |  | 81.89999999999999 |  | 0 |  | 4.779999999999999 | 298.14 |  |  | 4166.28 | 528.1299999999999
Marrero | 3 | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0
Rankin | 4 | 0 |  | 0 |  | 1.9 |  | 0 |  | 0 | 1.9
 |  | 180.95 |  | 138.12 |  | 104.69 |  | 0 |  | 52.5 | 476.26 |  |  | 4672.99 | 657.4499999999998
 |  |  | Totals
Standard time |  | 69.03 | 280.1 | 141.47 |  | 78.59 |  | 23.55 |  | 0 |  | 36.49 | <<You needed a SumProduct formula
Overtime |  | 19.62 | 137.44 | 39.48 |  | 49.53000000000001 |  | 44.23 |  | 0 |  | 4.2
Doubletime |  | 0 | 40.08000000000001 | 0 |  | 3.17 |  | 36.91 |  | 0 |  | 0
 |  | 88.65