Spreadsheet: 273445d1382714405-max-if-statement-not-working-across-multiple-sheets-yearly-results
Sheet: NEB

Nebraska Plainsmen
Year | Week | Home | Score | Away | Score |  | Most Scored at Home | Most Scored on Road | Least Scored at Home | Least Scored on Road | Most Against at Home | Most Against on Road | Least Against at Home | Least Against on Road | Franchise
2010 | Week 1 | New Orleans | 35 | Berlin | 17
2010 | Week 2 | Ft. Lauderdale | 20 | Berlin | 27
2010 | Week 4 | Berlin | 13 | Savannah | 24 |  |  |  |  |  |  |  |  |  | Berlin
2010 | Week 5 | Washington | 20 | Berlin | 10 |  |  |  |  |  |  |  |  |  | Baltimore
2010 | Week 6 | Berlin | 35 | Idaho | 3 |  |  |  |  |  |  |  |  |  | Nebraska
2010 | Week 7 | Berlin | 37 | Ft. Lauderdale | 0
2010 | Week 9 | Berlin | 28 | Ohio | 31
2010 | Week 10 | Corpus Christi | 20 | Berlin | 7
2010 | Week 11 | Savannah | 48 | Berlin | 17
2010 | Week 12 | Iowa | 45 | Berlin | 3
2010 | Week 13 | Berlin | 20 | Chicago | 10
2010 | Week 14 | Berlin | 23 | San Francisco | 33
2010 | Week 15 | Ohio | 27 | Berlin | 19
2010 | Week 16 | Berlin | 17 | Washington | 15
2010 | Week 17 | Berlin | 17 | [NAME] | 21
2011 | Week 1 | Chicago | 17 | Berlin | 35
2011 | Week 2 | Berlin | 39 | Savannah | 27
2011 | Week 3 | Idaho | 23 | Berlin | 26
2011 | Week 4 | [NAME] | 20 | Berlin | 30
2011 | Week 5 | Berlin | 22 | Washington | 25
2011 | Week 6 | Ohio | 13 | Berlin | 19
2011 | Week 7 | Berlin | 35 | Richmond | 9
2011 | Week 8 | Berlin | 27 | Idaho | 13
2011 | Week 9 | Savannah | 24 | Berlin | 31
2011 | Week 10 | Berlin | 20 | Ohio | 26
2011 | Week 11 | Washington | 23 | Berlin | 38
2011 | Week 12 | Richmond | 21 | Berlin | 45
2011 | Week 13 | Berlin | 27 | [NAME] | 24
2011 | Week 14 | Berlin | 10 | Chicago | 17
2011 | DIV. | Berlin | 26 | Ohio | 14
2011 | CONF. | Berlin | 16 | Savannah | 13
2011 | CB | Berlin | 17 | San Francisco | 20
2012 | Week 1 | Baltimore | 14 | Washington | 16
2012 | Week 2 | Baltimore | 24 | Puerto Rico | 10
2012 | Week 3 | Syracuse | 17 | Baltimore | 31
2012 | Week 4 | Baltimore | 16 | Idaho | 6
2012 | Week 5 | Savannah | 10 | Baltimore | 13
2012 | Week 6 | Pennsylvania | 17 | Baltimore | 20
2012 | Week 7 | Baltimore | 31 | Trinidad | 7
2012 | Week 8 | Orlando | 23 | Baltimore | 24
2012 | Week 9 | Baltimore | 23 | Savannah | 17
2012 | Week 10 | Baltimore | 22 | Syracuse | 13
2012 | Week 11 | Puerto Rico | 20 | Baltimore | 26
2012 | Week 12 | Idaho | 17 | Baltimore | 34
2012 | Week 13 | Baltimore | 27 | Orlando | 16
2012 | Week 14 | Trinidad | 6 | Baltimore | 28
2012 | Week 15 | Baltimore | 28 | Pennsylvania | 7
2012 | Week 16 | Washington | 13 | Baltimore | 24
2012 | DIV. | Baltimore | 16 | Puerto Rico | 6
2012 | CONF. | Baltimore | 16 | Washington | 14
2012 | CB | Baltimore | 32 | San Francisco | 27
2013 | Week 1 | Baltimore | 14 | Washington | 19
2013 | Week 2 | Springfield | 30 | Baltimore | 33
2013 | Week 3 | Montreal | 7 | Baltimore | 41
2013 | Week 4 | Baltimore | 36 | Iowa | 34
2013 | Week 5 | Orlando | 14 | Baltimore | 27
2013 | Week 6 | Los Angeles | 33 | Baltimore | 36
2013 | Week 7 | Baltimore | 13 | Savannah | 21
2013 | Week 8 | St. Louis | 24 | Baltimore | 27
2013 | Week 9 | Baltimore | 15 | West Texas | 16
2013 | Week 10 | Baltimore | 20 | Houston | 14
2013 | Week 11 | Puerto Rico | 16 | Baltimore | 21
2013 | Week 12 | Baltimore | 28 | Trinidad | 31
2013 | Week 13 | Baltimore | 27 | Tucson | 17
2013 | Week 14 | San Francisco | 27 | Baltimore | 26
2013 | Week 15 | Iowa | 20 | Baltimore | 17
2013 | Week 16 | Baltimore | 28 | Montreal | 7
2013 | Week 17 | Baltimore | 30 | Springfield | 15
2013 | Week 18 | Washington | 31 | Baltimore | 13
 | Week | Home | Score | Away | Score
 | Week 1 | Washington | 19 | Baltimore | 20
 | Week 2 | Columbus | 26 | Baltimore | 20
 | Week 3 | Baltimore | 17 | Atlantic City | 10
 | Week 4 | Los Angeles | 20 | Baltimore | 23
 | Week 5 | Baltimore | 16 | Colorado | 27
 | Week 6 | Baltimore | 17 | West Texas | 13
 | Week 7 | Montreal | 21 | Baltimore | 35
 | Week 8 | Orlando | 33 | Baltimore | 10
 | Week 9 | Baltimore | 17 | Springfield | 35
 | Week 10 | Baltimore | 30 | Washington | 24
 | Week 11 | Atlantic City | 7 | Baltimore | 22
 | Week 12 | Baltimore | 43 | Columbus | 3
 | Week 13 | Baltimore | 51 | Montreal | 14
 | Week 14 | Idaho | 24 | Baltimore | 6
 | Week 15 | Baltimore | 18 | Costa Rica | 15
 | Week 16 | Springfield | 20 | Baltimore | 17
 | WILD | Baltimore | 21 | Atlantic City | 7
 | DIV. | St. Louis | 28 | Baltimore | 21