Spreadsheet: 148318d1333353737-excel-2008-sum-formula-help-usesolver
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | NO GOOD
 | Next Stats |  |  | 2011 | 2012 Predict |  |  |  | 165
 | RK | Player | Team | HR▼ |  |  |  |  | 172 | 194
 | 1 | [NAME], J | TOR | 43 | 35 | 1 | McCann, B | 43 | 24 | 21 | 1
 | 2 | [NAME], C | NYY | 41 | 28 | 1 | Teixeira, M | 4 | 39 | 29 | 2
 | 4 | Teixeira, M | NYY | 39 | 29 | 1 | Cabrera, M | 21 | 30 | 42 | 3
 | 3 | Kemp, M | LAD | 39 | 28 | 1 | [NAME], A | 32 | 27 | 40 | 4
 | 5 | Fielder, P | MIL | 38 | 32 | 1 | Rodriguez, A | 96 | 16 | 24 | 5
 | 6 | Pujols, A | STL | 37 | 32 | 1 | Weeks, R | 65 | 20 | 20 | 6
 | 7 | Reynolds, M | BAL | 37 | 32 | 1 | Jones, G | 93 | 16 | 18 | 7
 | 8 | Uggla, D | ATL | 36 | 27 | 1
 | 9 | Stanton, M | FLA | 34 | 25 | 1
 | 11 | [NAME], R | PHI | 33 | 29 | 1
 | 10 | Braun, R | MIL | 33 | 26 | 1
 | 13 | [NAME], J | CIN | 32 | 25 | 1
 | 15 | Kinsler, I | TEX | 32 | 22 | 1
 | 12 | Beltre, A | TEX | 32 | 20 | 1 |  |  |  | 212 |  | 206 | 204
 | 14 | Ellsbury, J | BOS | 32 | 17 | 1 |  |  |  | 32 |  | 32 | 32
 | 17 | Konerko, P | CWS | 31 | 23 | 1 |  |  |  | 21 |  | 21 | 21
 | 18 | [NAME], E | TB | 31 | 23 | 1 |  |  |  | 37 |  | 37 | 37
 | 20 | Upton, J | ARI | 31 | 21 | 1 |  |  |  | 41 |  | 41 | 41
 | 19 | Morse, M | WSH | 31 | 19 | 1 |  |  |  | 96 |  | 105 | 105
 | 16 | Berkman, L | STL | 31 | 18 | 1 |  |  |  | 40 |  | 40 | 93
 | 21 | Cabrera, M | DET | 30 | 42 | 1 |  |  |  | 93 |  | 93 | 66
 | 24 | Tulowitzki, T | COL | 30 | 26 | 1
 | 23 | Napoli, M | TEX | 30 | 24 | 1
 | 22 | Hardy, J | BAL | 30 | 16 | 1
 | 28 | Votto, J | CIN | 29 | 29 | 1
 | 25 | Cruz, N | TEX | 29 | 26 | 1
 | 26 | Ortiz, D | BOS | 29 | 21 | 1
 | 29 | Willingham, J | OAK | 29 | 21 | 1
 | 27 | Trumbo, M | LAA | 29 | 18 | 1
 | 31 | Pena, C | CHC | 28 | 24 | 1
 | 30 | Cano, R | NYY | 28 | 23 | 1
 | 32 | [NAME], A | BOS | 27 | 40 | 1
 | 33 | Santana, C | CLE | 27 | 19 | 1
 | 37 | [NAME], A | CHC | 26 | 36 | 1
 | 34 | [NAME], C | COL | 26 | 28 | 1
 | 36 | Lind, A | TOR | 26 | 24 | 1
 | 35 | Hart, C | MIL | 26 | 23 | 1
 | 38 | Soriano, A | CHC | 26 | 17 | 1
 | 41 | Jones, A | BAL | 25 | 29 | 1
 | 40 | [NAME], J | TEX | 25 | 23 | 1
 | 42 | Wells, V | LAA | 25 | 19 | 1
 | 39 | Cabrera, A | CLE | 25 | 12 | 1
 | 44 | Quentin, C | CWS | 24 | 24 | 1
 | 43 | McCann, B | ATL | 24 | 21 | 1
 | 51 | Swisher, N | NYY | 23 | 23 | 1
 | 45 | Arencibia, J | TOR | 23 | 18 | 1
 | 46 | Gordon, A | KC | 23 | 18 | 1
 | 47 | [NAME], T | LAA | 23 | 17 | 1
 | 48 | McCutchen, A | PIT | 23 | 17 | 1
 | 50 | Sandoval, P | SF | 23 | 17 | 1
 | 52 | Upton, B | TB | 23 | 17 | 1
 | 49 | Morrison, L | FLA | 23 | 15 | 1
 | 55 | Pence, H | PHI | 22 | 22 | 1
 | 54 | Holliday, M | STL | 22 | 20 | 1
 | 56 | Wieters, M | BAL | 22 | 16 | 1
 | 53 | Beltran, C | SF | 22 | 12 | 1
 | 59 | [NAME], K | TOR | 21 | 18 | 1
 | 57 | Espinosa, D | WSH | 21 | 16 | 1
 | 58 | [NAME], F | ATL | 21 | 16 | 1
 | 60 | Pedroia, D | BOS | 21 | 15 | 1
 | 61 | Peralta, J | DET | 21 | 15 | 1
 | 66 | Werth, J | WSH | 20 | 21 | 1
 | 67 | Young, C | ARI | 20 | 21 | 1
 | 65 | Weeks, R | MIL | 20 | 20 | 1
 | 62 | Cuddyer, M | MIN | 20 | 17 | 1
 | 63 | Francoeur, J | KC | 20 | 17 | 1
 | 68 | Zobrist, B | TB | 20 | 17 | 1
 | 64 | Ibanez, R | PHI | 20 | 12 | 1
 | 76 | Sanchez, G | FLA | 19 | 18 | 1
 | 70 | Butler, B | KC | 19 | 16 | 1
 | 73 | [NAME], D | PIT | 19 | 16 | 1
 | 74 | Olivo, M | SEA | 19 | 16 | 1
 | 69 | [NAME], A | DET | 19 | 15 | 1
 | 71 | Hosmer, E | KC | 19 | 15 | 1
 | 72 | [NAME], M | TB | 19 | 14 | 1
 | 75 | [NAME], R | ARI | 19 | 10 | 1
 | 81 | [NAME], C | HOU | 18 | 16 | 1
 | 84 | Phillips, B | CIN | 18 | 16 | 1
 | 77 | Cabrera, M | KC | 18 | 15 | 1
 | 83 | Montero, M | ARI | 18 | 15 | 1
 | 80 | [NAME], H | LAA | 18 | 13 | 1
 | 78 | Heisey, C | CIN | 18 | 12 | 1
 | 82 | Martin, R | NYY | 18 | 11 | 1
 | 79 | Jones, C | ATL | 18 | 9 | 1
 | 86 | Soto, G | CHC | 17 | 16 | 1
 | 85 | Encarnacion, E | TOR | 17 | 15 | 1
 | 87 | Victorino, S | PHI | 17 | 14 | 1
 | 88 | Youkilis, K | BOS | 17 | 14 | 1
 | 96 | Rodriguez, A | NYY | 16 | 24 | 1
 | 93 | Jones, G | PIT | 16 | 18 | 1
 | 91 | [NAME], J | FLA | 16 | 17 | 1
 | 90 | Boesch, B | DET | 16 | 15 | 1
 | 94 | [NAME], M | TEX | 16 | 13 | 1
 | 97 | Rollins, J | PHI | 16 | 12 | 1
 | 92 | Damon, J | TB | 16 | 11 | 1
 | 89 | Barajas, R | LAD | 16 | 10 | 1
 | 95 | Nix, L | WSH | 16 | 10 | 1
 | 98 | Saltalamacchia, J | BOS | 16 | 10 | 1
 | 105 | Stubbs, D | CIN | 15 | 18 | 1
 | 99 | Markakis, N | BAL | 15 | 14 | 1
 | 101 | [NAME], A | CWS | 15 | 13 | 1
 | 103 | Smith, S | COL | 15 | 13 | 1
 | 107 | [NAME], D | MIN | 15 | 13 | 1
 | 108 | Wigginton, T | COL | 15 | 13 | 1
 | 102 | Ramos, W | WSH | 15 | 12 | 1
 | 104 | [NAME], J | SEA | 15 | 12 | 1
 | 100 | [NAME], J | PHI | 15 | 11 | 1
 | 106 | Thome, J | CLE | 15 | 9 | 1
 | 109 | Gomes, J | WSH | 14 | 15 | 1
 |  |  |  | 2551 | 2082 | 109