Spreadsheet: 797535d1663944962-help-sumifs-formula-with-date-range-and-text-exported_hours-7-
Sheet: Exported_Hours

Owner | Hour Type | Status | Date | Hours | Actual Cost | Revenue | Notes
Hour Type: Task Time (171) |  |  |  |  |  |  |  |  |  |  | Start | End
 |  |  |  | 171.45 | $0.00 | $30,951.62 |  |  |  | Date Range | 2022-09-02 00:00:00 | 2022-09-30 00:00:00
[NAME] | Task Time | Approved | 2022-08-16 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 1 | 0 | 108 |  |  |  | Total | 0
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-08-22 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-08-23 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-25 00:00:00 | 4 | 0 | 432
[NAME] | Task Time | Approved | 2022-08-26 00:00:00 | 2 | 0 | 216
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 3 | 0 | 324
[NAME] | Task Time | Approved | 2022-08-30 00:00:00 | 1.5 | 0 | 162
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 2.5 | 0 | 270
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 1.5 | 0 | 162
[NAME] | Task Time | Approved | 2022-09-02 00:00:00 | 1.5 | 0 | 162
[NAME] | Task Time | Approved | 2022-09-06 00:00:00 | 3 | 0 | 324
[NAME] | Task Time | Approved | 2022-09-06 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-07 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 2.5 | 0 | 270
[NAME] | Task Time | Approved | 2022-09-09 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-14 00:00:00 | 2.5 | 0 | 270
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 4 | 0 | 432
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 0.75 | 0 | 81
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 2 | 0 | 216
[NAME] | Task Time | Approved | 2022-09-14 00:00:00 | 0.5 | 0 | 54
[NAME] | Task Time | Approved | 2022-09-16 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 2.25 | 0 | 243
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 0.75 | 0 | 81
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 1 | 0 | 108
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 1.5 | 0 | 202.5
[NAME] | Task Time | Submitted | 2022-09-21 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-15 00:00:00 | 1 | 0 | 105
[NAME] | Task Time | Approved | 2022-08-09 00:00:00 | 4 | 0 | 420
[NAME] | Task Time | Approved | 2022-08-10 00:00:00 | 4 | 0 | 420
[NAME] | Task Time | Approved | 2022-08-08 00:00:00 | 0.5 | 0 | 52.5
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 0.25 | 0 | 26.25
Jordan | Task Time | Approved | 2022-08-17 00:00:00 | 0.75 | 0 | 101.25
Jordan | Task Time | Approved | 2022-08-18 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-07-22 00:00:00 | 1 | 0 | 211.5
[NAME] | Task Time | Approved | 2022-08-04 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-08-11 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-08-12 00:00:00 | 1.5 | 0 | 317.25
[NAME] | Task Time | Approved | 2022-08-15 00:00:00 | 0.75 | 0 | 158.625
[NAME] | Task Time | Approved | 2022-08-16 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 2.5 | 0 | 528.75
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 1 | 0 | 211.5
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-07-22 00:00:00 | 0.5 | 0 | 105.75
[NAME] | Task Time | Approved | 2022-08-24 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-25 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-22 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-23 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-26 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-08-30 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 2 | 0 | 432
[NAME] | Task Time | Approved | 2022-09-02 00:00:00 | 1 | 0 | 216
[NAME] | Task Time | Approved | 2022-09-09 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-06 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-13 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-14 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-16 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-12 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 0.5 | 0 | 108
[NAME] | Task Time | Approved | 2022-05-27 00:00:00 | 0.2 | 0 | 60
[NAME] | Task Time | Approved | 2022-06-01 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-06-07 00:00:00 | 0.75 | 0 | 225
[NAME] | Task Time | Approved | 2022-06-09 00:00:00 | 1 | 0 | 300
[NAME] | Task Time | Approved | 2022-06-10 00:00:00 | 0.6 | 0 | 180
[NAME] | Task Time | Approved | 2022-06-14 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-06-15 00:00:00 | 0.25 | 0 | 75
[NAME] | Task Time | Approved | 2022-06-24 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-08-04 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-08-08 00:00:00 | 1 | 0 | 300
[NAME] | Task Time | Approved | 2022-08-12 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 0.4 | 0 | 120
[NAME] | Task Time | Approved | 2022-08-19 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-08-23 00:00:00 | 0.75 | 0 | 225
[NAME] | Task Time | Approved | 2022-08-22 00:00:00 | 0.75 | 0 | 225
[NAME] | Task Time | Approved | 2022-08-26 00:00:00 | 0.25 | 0 | 75
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 1 | 0 | 300
[NAME] | Task Time | Approved | 2022-09-08 00:00:00 | 1 | 0 | 300
[NAME] | Task Time | Submitted | 2022-09-22 00:00:00 | 0.5 | 0 | 150
[NAME] | Task Time | Approved | 2022-05-19 00:00:00 | 0.5 | 0 | 117
[NAME] | Task Time | Approved | 2022-05-26 00:00:00 | 0.5 | 0 | 117
[NAME] | Task Time | Approved | 2022-06-09 00:00:00 | 0.5 | 0 | 117
[NAME] | Task Time | Approved | 2022-08-12 00:00:00 | 1 | 0 | 234
[NAME] | Task Time | Approved | 2022-09-01 00:00:00 | 1 | 0 | 234
[NAME] | Task Time | Approved | 2022-09-15 00:00:00 | 1.5 | 0 | 351
[NAME] | Task Time | Approved | 2022-05-02 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-05-03 00:00:00 | 3 | 0 | 870
[NAME] | Task Time | Approved | 2022-05-05 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-05-16 00:00:00 | 4 | 0 | 1160
[NAME] | Task Time | Approved | 2022-05-17 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-05-18 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-05-19 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-06-21 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-06-22 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-06-23 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-07-05 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-07-06 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-07-07 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-07-08 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-08-29 00:00:00 | 1 | 0 | 290
[NAME] | Task Time | Approved | 2022-08-30 00:00:00 | 2 | 0 | 580
[NAME] | Task Time | Approved | 2022-08-31 00:00:00 | 1.5 | 0 | 435
[NAME] | Task Time | Approved | 2022-05-03 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-02 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-05 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-09 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-10 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-11 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-12 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-05-17 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-18 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-19 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-20 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-23 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-05-24 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-05-25 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-05-26 00:00:00 | 1.5 | 0 | 202.5
[NAME] | Task Time | Approved | 2022-05-27 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-01 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-02 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-13 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-06-14 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-06-15 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-06-16 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-06-17 00:00:00 | 0.75 | 0 | 101.25
[NAME] | Task Time | Approved | 2022-06-23 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-07-01 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-07 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-08 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-07-12 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-13 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-15 00:00:00 | 2 | 0 | 270
[NAME] | Task Time | Approved | 2022-07-22 00:00:00 | 2 | 0 | 270
[NAME] | Task Time | Approved | 2022-07-21 00:00:00 | 2.5 | 0 | 337.5
[NAME] | Task Time | Approved | 2022-07-20 00:00:00 | 1 | 0 | 135
[NAME] | Task Time | Approved | 2022-07-26 00:00:00 | 0.75 | 0 | 101.25
[NAME] | Task Time | Approved | 2022-07-25 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-27 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-29 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-07-28 00:00:00 | 0.75 | 0 | 101.25
[NAME] | Task Time | Approved | 2022-08-05 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-08-02 00:00:00 | 2 | 0 | 270
[NAME] | Task Time | Approved | 2022-08-03 00:00:00 | 2.5 | 0 | 337.5
[NAME] | Task Time | Approved | 2022-08-04 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-10 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-11 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-15 00:00:00 | 0.25 | 0 | 33.75
[NAME] | Task Time | Approved | 2022-08-16 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-17 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-19 00:00:00 | 0.5 | 0 | 67.5
[NAME] | Task Time | Approved | 2022-08-18 00:00:00 | 1 | 0 | 211.5
 |  |  | (SUMIF=(A4:A174,"Kyle Anderson",E4:E174),D4:D174,">="8/15/22,K3,,(A4:A174,"Kyle Anderson",E4:E174))