Spreadsheet: 752722d1634911197-subtotal-function-with-criteria-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | TOTAL HOURS
 |  |  |  |  |  |  |  |  |  | ST HOURS |  | Need to be able to filter on column E(Job) and sum column L when column P equals "ST"
payEnd | Description | FullName | PRCo | Job | JobDescription | JobTitle | Phase | PREndDate | Employee | EarnCode | Hours | Amt | fullAmt | Rate | payType
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER FOREMAN |  | 2021-10-19 00:00:00 | 100010 | 1 | 8 | 319.76 | 789.9 | 39.97 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER FOREMAN |  | 2021-10-19 00:00:00 | 100010 | 1 | 8 | 319.76 | 789.87 | 39.97 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER FOREMAN |  | 2021-10-19 00:00:00 | 100022 | 1 | 8 | 342.8 | 820.77 | 42.85 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | [NAME] |  | 2021-10-19 00:00:00 | 100813 | 1 | 4 | 208.6 | 460.25 | 52.15 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER FOREMAN |  | 2021-10-19 00:00:00 | 102388 | 1 | 8 | 357.6 | 840.63 | 44.7 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER FOREMAN |  | 2021-10-19 00:00:00 | 102388 | 1 | 8 | 357.6 | 840.59 | 44.7 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106656 | 1 | 8 | 177.44 | 489.71 | 22.18 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106656 | 1 | 8 | 177.44 | 489.71 | 22.18 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106656 | 1 | 8 | 177.44 | 489.71 | 22.18 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | PIPEFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106656 | 1 | 4 | 88.72 | 244.9 | 22.18 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 101240 | 1 | 8 | 364.08 | 888.08 | 45.51 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 101240 | 1 | 2 | 91.02 | 222.02 | 45.51 | ST
2021-10-19 00:00:00 |  |  |  | 11201010 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 101240 | 1 | 8 | 364.08 | 888.15 | 45.51 | ST
2021-10-19 00:00:00 |  |  |  | 1518001 |  | Journeyman |  | 2021-10-19 00:00:00 | 103602 | 1 | 8 | 342.8 | 820.76 | 42.85 | OT
2021-10-19 00:00:00 |  |  |  | 1518001 |  | Journeyman |  | 2021-10-19 00:00:00 | 103602 | 1 | 8 | 342.8 | 820.76 | 42.85 | OT
2021-10-19 00:00:00 |  |  |  | 1518001 |  | Journeyman |  | 2021-10-19 00:00:00 | 103602 | 1 | 8 | 342.8 | 820.76 | 42.85 | OT
2021-10-19 00:00:00 |  |  |  | 1518001 |  | Journeyman |  | 2021-10-19 00:00:00 | 103602 | 1 | 8 | 342.8 | 820.76 | 42.85 | OT
2021-10-19 00:00:00 |  |  |  | 1518001 |  | STEAMFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106268 | 1 | 8 | 188.08 | 548.32 | 23.51 | OT
2021-10-19 00:00:00 |  |  |  | 1518001 |  | STEAMFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106268 | 1 | 8 | 188.08 | 548.32 | 23.51 | ST
2021-10-19 00:00:00 |  |  |  | 1518001 |  | STEAMFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106268 | 1 | 8 | 188.08 | 548.32 | 23.51 | ST
2021-10-19 00:00:00 |  |  |  | 1518001 |  | STEAMFITTER APPRENTICE |  | 2021-10-19 00:00:00 | 106268 | 1 | 8 | 188.08 | 548.26 | 23.51 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | N/A |  | 2021-10-19 00:00:00 | 107159 | 1 | 8 | 120 | 384.24 | 15 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 100781 | 1 | 8 | 354.08 | 874.68 | 44.26 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | N/A |  | 2021-10-19 00:00:00 | 107094 | 1 | 8 | 207.84 | 597.75 | 25.98 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | N/A |  | 2021-10-19 00:00:00 | 107094 | 1 | 8 | 207.84 | 597.78 | 25.98 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | N/A |  | 2021-10-19 00:00:00 | 107176 | 1 | 8 | 310.08 | 817.57 | 38.76 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | N/A |  | 2021-10-19 00:00:00 | 107176 | 1 | 8 | 310.08 | 817.53 | 38.76 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Service Technician Apprentice |  | 2021-10-19 00:00:00 | 105267 | 1 | 8 | 329.6 | 815.64 | 41.2 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | SERVICE APPRENTICE |  | 2021-10-19 00:00:00 | 106036 | 1 | 6.5 | 254.8 | 635.07 | 39.2 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 100781 | 1 | 8 | 354.08 | 874.68 | 44.26 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 100781 | 1 | 8 | 354.08 | 874.68 | 44.26 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 100781 | 1 | 8 | 354.08 | 874.68 | 44.26 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Service Technician |  | 2021-10-19 00:00:00 | 101261 | 1 | 6 | 318 | 706.65 | 53 | ST
2021-10-19 00:00:00 |  |  |  | 25665500 |  | [NAME] |  | 2021-10-19 00:00:00 | 100813 | 1 | 4 | 208.6 | 460.25 | 52.15 | DT
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 100781 | 1 | 8 | 354.08 | 874.73 | 44.26 | DT
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 101240 | 1 | 8 | 364.08 | 888.08 | 45.51 | DT
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 101240 | 1 | 6 | 273.06 | 666.07 | 45.51 | DT
2021-10-19 00:00:00 |  |  |  | 25665500 |  | Sheet Metal Foreman |  | 2021-10-19 00:00:00 | 101240 | 1 | 8 | 364.08 | 888.08 | 45.51 | ST
2021-10-19 00:00:00 |  |  |  | 14182500 |  | N/A |  | 2021-10-19 00:00:00 | 107094 | 1 | 8 | 207.84 | 597.75 | 25.98 | ST
2021-10-19 00:00:00 |  |  |  | 14182500 |  | N/A |  | 2021-10-19 00:00:00 | 107094 | 1 | 8 | 207.84 | 597.75 | 25.98 | ST
2021-10-19 00:00:00 |  |  |  | 14182500 |  | N/A |  | 2021-10-19 00:00:00 | 107094 | 1 | 8 | 207.84 | 597.75 | 25.98 | ST
2021-10-19 00:00:00 |  |  |  | 14182500 |  | N/A |  | 2021-10-19 00:00:00 | 107159 | 1 | 8 | 120 | 384.23 | 15 | ST
2021-10-19 00:00:00 |  |  |  | 14182500 |  | N/A |  | 2021-10-19 00:00:00 | 107159 | 1 | 8 | 120 | 384.23 | 15 | ST
2021-10-19 00:00:00 |  |  |  | 14182500 |  | N/A |  | 2021-10-19 00:00:00 | 107159 | 1 | 8 | 120 | 384.23 | 15 | ST
2021-10-19 00:00:00 |  |  |  | 14182500 |  | N/A |  | 2021-10-19 00:00:00 | 107159 | 1 | 8 | 120 | 384.23 | 15 | ST