Spreadsheet: 768480d1644995738-help-simplyfying-a-formula-from-a-very-long-detailed-sum-to-sumproduct-with-index-match-temp
Sheet: Sheet1

Boston Red Sox        (BATS3 Pre-Expansion) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Game 1 |  |  | Game 2 |  |  | Game 3 |  |  | Game 4 |  |  | Game 5 |  |  | Game 6 |  |  | Game 7 |  |  | Game 8 |  |  | Game 9 |  |  | Game 10 |  |  | Game 11 |  |  | Game 12 |  |  | Game 13 |  |  | Game 14 |  |  | Game 15 |  |  | Game 16 |  |  | Game 17 |  |  | Game 18 |  |  | Game 19 |  |  | Game 20 |  |  | Game 21 |  |  | Game 22 |  |  | Game 23 |  |  | Game 24 |  |  | Game 25 |  |  | Game 26 |  |  | Game 27 |  |  | Game 28 |  |  | Game 29 |  |  | Game 30 |  |  | Game 31 |  |  | Game 32 |  |  | Game 33 |  |  | Game 34 |  |  | Game 35 |  |  | Game 36 |  |  | Game 37 |  |  | Game 38 |  |  | Game 39 |  |  | Game 40 |  |  | Game 41 |  |  | Game 42 |  |  | Game 43 |  |  | Game 44 |  |  | Game 45 |  |  | Game 46 |  |  | Game 47 |  |  | Game 48 |  |  | Game 49 |  |  | Game 50 |  |  | Game 51 |  |  | Game 52 |  |  | Game 53 |  |  | Game 54 |  |  | Game 55 |  |  | Game 56 |  |  | Game 57 |  |  | Game 58 |  |  | Game 59 |  |  | Game 60 |  |  | Game 61 |  |  | Game 62 |  |  | Game 63 |  |  | Game 64 |  |  | Game 65 |  |  | Game 66 |  |  | Game 67 |  |  | Game 68 |  |  | Game 69 |  |  | Game 70 |  |  | Game 71 |  |  | Game 72 |  |  | Game 73 |  |  | Game 74 |  |  | Game 75 |  |  | Game 76 |  |  | Game 77 |  |  | Game 78 |  |  | Game 79 |  |  | Game 80 |  |  | Game 81 |  |  | Game 82 |  |  | Game 83 |  |  | Game 84 |  |  | Game 85 |  |  | Game 86 |  |  | Game 87 |  |  | Game 88 |  |  | Game 89 |  |  | Game 90 |  |  | Game 91 |  |  | Game 92 |  |  | Game 93 |  |  | Game 94 |  |  | Game 95 |  |  | Game 96 |  |  | Game 97 |  |  | Game 98 |  |  | Game 99 |  |  | Game 100 |  |  | Game 101 |  |  | Game 102 |  |  | Game 103 |  |  | Game 104 |  |  | Game 105 |  |  | Game 106 |  |  | Game 107 |  |  | Game 108 |  |  | Game 109 |  |  | Game 110 |  |  | Game 111 |  |  | Game 112 |  |  | Game 113 |  |  | Game 114 |  |  | Game 115 |  |  | Game 116 |  |  | Game 117 |  |  | Game 118 |  |  | Game 119 |  |  | Game 120 |  |  | Game 121 |  |  | Game 122 |  |  | Game 123 |  |  | Game 124 |  |  | Game 125 |  |  | Game 126 |  |  | Game 127 |  |  | Game 128 |  |  | Game 129 |  |  | Game 130 |  |  | Game 131 |  |  | Game 132 |  |  | Game 133 |  |  | Game 134 |  |  | Game 135 |  |  | Game 136 |  |  | Game 137 |  |  | Game 138 |  |  | Game 139 |  |  | Game 140 |  |  | Game 141 |  |  | Game 142 |  |  | Game 143 |  |  | Game 144 |  |  | Game 145 |  |  | Game 146 |  |  | Game 147 |  |  | Game 148 |  |  | Game 149 |  |  | Game 150 |  |  | Game 151 |  |  | Game 152 |  |  | Game 153 |  |  | Game 154 |  |  | Game 155 |  |  | Game 156 |  |  | Game 157 |  |  | Game 158 |  |  | Game 159 |  |  | Game 160 |  |  | Game 161
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R | DEF | IP | R
Lineup |  | POS1 | DEF | POS2 | DEF | POS3 | DEF | POS4 | DEF | POS5 | DEF | POS6 | DEF | AVG | SLG | OBP | SPD | P | P* | SO | CTRL | BFR |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | . |  | . | .
Carrigan, [NAME] |  | C | 7 |  |  |  |  |  |  |  |  |  |  | 0.296 | 0.368 | 0.341 |  |  |  |  |  |  | C
[NAME], [NAME] |  | 3B | 6 |  |  |  |  |  |  |  |  |  |  | 0.332 | 0.495 | 0.375 | F |  |  |  |  |  | 3B
Cramer, Doc |  | OF | 2 |  |  |  |  |  |  |  |  |  |  | 0.303 | 0.384 | 0.34
[NAME], Dom |  | RF | 2 |  |  |  |  |  |  |  |  |  |  | 0.328 | 0.452 | 0.414 | F |  |  |  |  |  | RF
Doerr, [NAME] |  | 2B | 8 |  |  |  |  |  |  |  |  |  |  | 0.294 | 0.519 | 0.367 |  |  |  |  |  |  | 2B
[NAME], [NAME] |  | 1B | 2 | OF | 1 | 2B | 5 |  |  |  |  |  |  | 0.339 | 0.452 | 0.4 | F
[NAME], [NAME] |  | 1B | 2 | OF | 1 |  |  |  |  |  |  |  |  | 0.291 | 0.484 | 0.399
Goodman, [NAME] |  | 2B | 7 | 1B | 4 | 3B | 4 | OF | 2 |  |  |  |  | 0.354 | 0.455 | 0.427
[NAME], Jackie |  | CF | 2 |  |  |  |  |  |  |  |  |  |  | 0.286 | 0.535 | 0.396 | F |  |  |  |  |  | CF
Malzone, [NAME] |  | 3B | 4 |  |  |  |  |  |  |  |  |  |  | 0.292 | 0.427 | 0.326
Pesky, [NAME] |  | SS | 9 | 3B | 5 | 2B | 7 |  |  |  |  |  |  | 0.335 | 0.427 | 0.401 | F |  |  |  |  |  | SS
Runnels, [NAME] |  | 2B | 7 | 1B | 4 |  |  |  |  |  |  |  |  | 0.322 | 0.436 | 0.415 |  |  |  |  |  |  | 1B
[NAME], [NAME] |  | SS | 9 | 3B | 4 |  |  |  |  |  |  |  |  | 0.29 | 0.539 | 0.391
White, [NAME] |  | C | 8 |  |  |  |  |  |  |  |  |  |  | 0.282 | 0.426 | 0.307 | S
[NAME], [NAME] |  | LF | 2 |  |  |  |  |  |  |  |  |  |  | 0.406 | 0.735 | 0.533 |  |  |  |  |  |  | LF
Wood, [NAME] |  | P | 2 | OF | 2 |  |  |  |  |  |  |  |  |  |  |  |  | A&B |  | XY | Z | 35 | P
Leonard, Dutch |  | P | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | S | A&C |  | XY | Z | 31 |  |  |  | P
Young, Cy |  | P | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | S | A&C |  | X | Z | 35 |  |  |  |  |  |  | P
Mays, [NAME] |  | P | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  | Z | 34 |  |  |  |  |  |  |  |  |  | P
Parnell, [NAME] |  | P | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  | Y |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  | P
[NAME], [NAME] |  | P | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  | Z | 29
[NAME], Tex |  | P | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  | X | Z | 31
Jones, [NAME] |  | P | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | S | B |  | Y | Z | 32
[NAME], [NAME] |  | P | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | S | B |  | Y |  | 31
Kinder, Ellis |  | P | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | S |  | A&C*
GAME CHANGES Subs changes, and removals. Every change must be entered. Do the following  for anyone involved in the change. Enter name, Position Code, and Defensive Value on left side. Enter position code under the games DEF  column. Player in the game who is leaving or moving get a - after their original starting position.             Changes                       POS   DEF                                                                           Notes