Spreadsheet: 195383d1353507681-sum-if-based-on-two-criteria-book1111
Sheet: Master (4)

 | CSA Bonus Program |  |  | Logs in House
 |  |  |  | 70 |  |  |  |  | 14 |  |  |  |  | 11 |  |  |  |  | Speed |  |  |  | Genral Form        and Manner | Missing Logs | Identical Logs for same day | Different logs for same day | Clean Week of logs | Trk Violation | Trl Violation | Driver | Not Current | No Previous 7 | 70 | 14 | 11 | General | Over Weight | Failure to yield | Lane Change | Traffic control device | Parking in road | Following too close | Speeding 1-5 | Speeding 6-10 | Speeding 11-14 | Speeding 11-14 | No Seatbelt | Speeding | [NAME].
 |  |  |  | 0-15 min | 16-30 min | 31 min-1 hr | 1.1 hr-2 hr | 2.1 hr + |  |  |  |  |  |  |  |  |  |  | 0-5 MPH | 6-10 MPH | 11-15 MPH | 16+ MPH
 | Week | Week Ending | Driver | 0 | 1 | 2 | 3 | 5 | 0 | 1 | 2 | 3 | 5 | 0 | 1 | 2 | 3 | 5 | 0 | 1 | 2 | 3 | 1 | 2 | 1 | 5 | -0.25 | 5 | 5 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 15 | 10 | 10 | 10 | 10 | 15 | 5 | 5 | 15 | 20 | 5 | 5 | 5
1 | Week 1 |  | [NAME], [NAME] | 1 | 1
1 | Week 1 |  | Bange, Vincent
1 | Week 1 |  | Berry, [NAME]
1 | Week 1 |  | Blickhan, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Brunner III, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | [NAME], Marvin
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Burton, Dennis
1 | Week 1 |  | Byrd, [NAME]
1 | Week 1 |  | Cannon, [NAME]
1 | Week 1 |  | Childress, [NAME]
1 | Week 1 |  | Cole, [NAME] ([NAME])
1 | Week 1 |  | Cowell, [NAME]
1 | Week 1 |  | Cremering, [NAME]
1 | Week 1 |  | Crose, [NAME]
1 | Week 1 |  | Daugherty, [NAME]
1 | Week 1 |  | Dellinger, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Doty, [NAME]
1 | Week 1 |  | Driver, Rose
1 | Week 1 |  | Duvall, Dale
1 | Week 1 |  | Eades, [NAME]
1 | Week 1 |  | Eklund, [NAME]
1 | Week 1 |  | Engelbrecht, [NAME]
1 | Week 1 |  | Farrar, [NAME] ([NAME])
1 | Week 1 |  | Fessler, [NAME]
1 | Week 1 |  | Frazer, [NAME]
1 | Week 1 |  | Galbraith, [NAME] ([NAME])
1 | Week 1 |  | [NAME] (Paulie)
1 | Week 1 |  | Germain, Willard (Nick)
1 | Week 1 |  | Gibb, [NAME]
1 | Week 1 |  | Gibson, Thomas (Tom)
1 | Week 1 |  | Goergen, [NAME]
1 | Week 1 |  | Gorman, [NAME]
1 | Week 1 |  | Graves, Charles (Chuck)
1 | Week 1 |  | Green, [NAME] ([NAME])
1 | Week 1 |  | Green, [NAME]
1 | Week 1 |  | Gribble, Morgan
1 | Week 1 |  | Griffin, [NAME] ([NAME])
1 | Week 1 |  | Grover, Dustin
1 | Week 1 |  | Hacker, [NAME]
1 | Week 1 |  | Hagenhoff, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Hammond, Donald
1 | Week 1 |  | Haney, Brent
1 | Week 1 |  | Hardy, Traci
1 | Week 1 |  | Harpole, [NAME]
1 | Week 1 |  | Harrelson, [NAME]
1 | Week 1 |  | Hart, [NAME]
1 | Week 1 |  | Hawley, [NAME]
1 | Week 1 |  | Hicks, Dennis
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Ikerd, [NAME]
1 | Week 1 |  | Ingro, [NAME]
1 | Week 1 |  | Irby, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Jacobs, [NAME]
1 | Week 1 |  | Jalkanen, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Jones, [NAME] ([NAME])
1 | Week 1 |  | Jones, Nicky
1 | Week 1 |  | Jones, [NAME] (Butch)
1 | Week 1 |  | [NAME], [NAME] ([NAME])
1 | Week 1 |  | Krumenacker, [NAME]
1 | Week 1 |  | LaPorte, [NAME] ([NAME])
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Legler, [NAME])
1 | Week 1 |  | Logan, [NAME]
1 | Week 1 |  | Long, Clyde
1 | Week 1 |  | Lorenson, [NAME]
1 | Week 1 |  | Lovell, [NAME]
1 | Week 1 |  | Lutjen, [NAME]
1 | Week 1 |  | Martin, [NAME]
1 | Week 1 |  | Martin, [NAME] ([NAME])
1 | Week 1 |  | Maurer, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Moldenhauer, [NAME]
1 | Week 1 |  | Morris, [NAME] (Gene)
1 | Week 1 |  | Moshier, Justin
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Nulsen, [NAME]
1 | Week 1 |  | [NAME], [NAME] (Zach)
1 | Week 1 |  | Parker, [NAME]
1 | Week 1 |  | Phillips, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Porter, Richard ([NAME])
1 | Week 1 |  | Potts, [NAME] ([NAME])
1 | Week 1 |  | Powers, [NAME]
1 | Week 1 |  | Proper, Stanley
1 | Week 1 |  | Rainey, Rebecca
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Rhoades, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Ricketts, Stephen
1 | Week 1 |  | Riley, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Rodehaver, Scott
1 | Week 1 |  | Rogers, [NAME]
1 | Week 1 |  | [NAME], Terrence
1 | Week 1 |  | Sayles, [NAME]
1 | Week 1 |  | Schafer, Brent
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Sevier, [NAME]
1 | Week 1 |  | Smith, [NAME]
1 | Week 1 |  | Smith, Dennis
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Smith, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Spiker, [NAME]
1 | Week 1 |  | Spindler, [NAME]
1 | Week 1 |  | Strahl, [NAME]
1 | Week 1 |  | Subelka, [NAME]
1 | Week 1 |  | Svoboda, [NAME]
1 | Week 1 |  | Tallman, [NAME]
1 | Week 1 |  | [NAME], [NAME] ([NAME])
1 | Week 1 |  | Thompson, [NAME]
1 | Week 1 |  | Thompson, [NAME]
1 | Week 1 |  | Tippett, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Velasquez, [NAME] (Chirs)
1 | Week 1 |  | Walters, [NAME]
1 | Week 1 |  | Warner, C Curtis (Curt)
1 | Week 1 |  | Warning, [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | [NAME], [NAME] ([NAME])
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | [NAME], Harlon
1 | Week 1 |  | [NAME], [NAME]
1 | Week 1 |  | Wilson, Dwaine
1 | Week 1 |  | Wittenauer, [NAME]
1 | Week 1 |  | Wood, Megan
1 | Week 1 |  | Young, [NAME]
1 | Week 1 |  | Zanger, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Bange, Vincent
2 | Week 2 |  | Berry, [NAME]
2 | Week 2 |  | Blickhan, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Brunner III, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | [NAME], Marvin
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Burton, Dennis
2 | Week 2 |  | Byrd, [NAME]
2 | Week 2 |  | Cannon, [NAME]
2 | Week 2 |  | Childress, [NAME]
2 | Week 2 |  | Cole, [NAME] ([NAME])
2 | Week 2 |  | Cowell, [NAME]
2 | Week 2 |  | Cremering, [NAME]
2 | Week 2 |  | Crose, [NAME]
2 | Week 2 |  | Daugherty, [NAME]
2 | Week 2 |  | Dellinger, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Doty, [NAME]
2 | Week 2 |  | Driver, Rose
2 | Week 2 |  | Duvall, Dale
2 | Week 2 |  | Eades, [NAME]
2 | Week 2 |  | Eklund, [NAME]
2 | Week 2 |  | Engelbrecht, [NAME]
2 | Week 2 |  | Farrar, [NAME] ([NAME])
2 | Week 2 |  | Fessler, [NAME]
2 | Week 2 |  | Frazer, [NAME]
2 | Week 2 |  | Galbraith, [NAME] ([NAME])
2 | Week 2 |  | [NAME] (Paulie)
2 | Week 2 |  | Germain, Willard (Nick)
2 | Week 2 |  | Gibb, [NAME]
2 | Week 2 |  | Gibson, Thomas (Tom)
2 | Week 2 |  | Goergen, [NAME]
2 | Week 2 |  | Gorman, [NAME]
2 | Week 2 |  | Graves, Charles (Chuck)
2 | Week 2 |  | Green, [NAME] ([NAME])
2 | Week 2 |  | Green, [NAME]
2 | Week 2 |  | Gribble, Morgan
2 | Week 2 |  | Griffin, [NAME] ([NAME])
2 | Week 2 |  | Grover, Dustin
2 | Week 2 |  | Hacker, [NAME]
2 | Week 2 |  | Hagenhoff, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Hammond, Donald
2 | Week 2 |  | Haney, Brent
2 | Week 2 |  | Hardy, Traci
2 | Week 2 |  | Harpole, [NAME]
2 | Week 2 |  | Harrelson, [NAME]
2 | Week 2 |  | Hart, [NAME]
2 | Week 2 |  | Hawley, [NAME]
2 | Week 2 |  | Hicks, Dennis
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Ikerd, [NAME]
2 | Week 2 |  | Ingro, [NAME]
2 | Week 2 |  | Irby, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Jacobs, [NAME]
2 | Week 2 |  | Jalkanen, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Jones, [NAME] ([NAME])
2 | Week 2 |  | Jones, Nicky
2 | Week 2 |  | Jones, [NAME] (Butch)
2 | Week 2 |  | [NAME], [NAME] ([NAME])
2 | Week 2 |  | Krumenacker, [NAME]
2 | Week 2 |  | LaPorte, [NAME] ([NAME])
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Legler, [NAME])
2 | Week 2 |  | Logan, [NAME]
2 | Week 2 |  | Long, Clyde
2 | Week 2 |  | Lorenson, [NAME]
2 | Week 2 |  | Lovell, [NAME]
2 | Week 2 |  | Lutjen, [NAME]
2 | Week 2 |  | Martin, [NAME]
2 | Week 2 |  | Martin, [NAME] ([NAME])
2 | Week 2 |  | Maurer, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Moldenhauer, [NAME]
2 | Week 2 |  | Morris, [NAME] (Gene)
2 | Week 2 |  | Moshier, Justin
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Nulsen, [NAME]
2 | Week 2 |  | [NAME], [NAME] (Zach)
2 | Week 2 |  | Parker, [NAME]
2 | Week 2 |  | Phillips, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Porter, Richard ([NAME])
2 | Week 2 |  | Potts, [NAME] ([NAME])
2 | Week 2 |  | Powers, [NAME]
2 | Week 2 |  | Proper, Stanley
2 | Week 2 |  | Rainey, Rebecca
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Rhoades, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Ricketts, Stephen
2 | Week 2 |  | Riley, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Rodehaver, Scott
2 | Week 2 |  | Rogers, [NAME]
2 | Week 2 |  | [NAME], Terrence
2 | Week 2 |  | Sayles, [NAME]
2 | Week 2 |  | Schafer, Brent
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Sevier, [NAME]
2 | Week 2 |  | Smith, [NAME]
2 | Week 2 |  | Smith, Dennis
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Smith, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Spiker, [NAME]
2 | Week 2 |  | Spindler, [NAME]
2 | Week 2 |  | Strahl, [NAME]
2 | Week 2 |  | Subelka, [NAME]
2 | Week 2 |  | Svoboda, [NAME]
2 | Week 2 |  | Tallman, [NAME]
2 | Week 2 |  | [NAME], [NAME] ([NAME])
2 | Week 2 |  | Thompson, [NAME]
2 | Week 2 |  | Thompson, [NAME]
2 | Week 2 |  | Tippett, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Velasquez, [NAME] (Chirs)
2 | Week 2 |  | Walters, [NAME]
2 | Week 2 |  | Warner, C Curtis (Curt)
2 | Week 2 |  | Warning, [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | [NAME], [NAME] ([NAME])
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | [NAME], Harlon
2 | Week 2 |  | [NAME], [NAME]
2 | Week 2 |  | Wilson, Dwaine
2 | Week 2 |  | Wittenauer, [NAME]
2 | Week 2 |  | Wood, Megan
2 | Week 2 |  | Young, [NAME]
2 | Week 2 |  | Zanger, [NAME]