Spreadsheet: 182125d1348285242-rolling-totals-formula-help-running-totals-update
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Week 1 |  |  |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5 |  |  |  |  | Week 6 |  |  |  |  | Week 7 |  |  |  |  | Week 8
 | Example 1 |  |  | Game Total |  | Starting | Average 1 |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total:
 | 8 |  |  |  |  |  | Average 2 |  |  |  |  | Games: |  |  |  |  | Games: |  |  |  |  | Games: |  |  |  |  | Games: |  |  |  |  | Games: |  |  |  |  | Games: |  |  |  |  | Games: |  |  |  |  | Games:
 | 7 | 222 | 124 | 122 |  |  | Average 3 |  |  |  |  | Average: |  |  |  |  | Average: |  |  |  |  | Average: |  |  |  |  | Average: |  |  |  |  | Average: |  |  |  |  | Average: |  |  |  |  | Average: |  |  |  |  | Average:
 | 6 | 214 | 221 | 112 |  |  | Average 4 |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8
 | 5 | 125 | 236 | 214 |  |  | Average 5 |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 | 231 | 159 | 178
 | 4 | 236 | 251 | 128 |  |  | Average 6 |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 | 222 | 224 | 214 |  | 6 | 222 | 224 | 214
 | 3 | 145 | 287 | 147 |  |  | Average 7 |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 | 214 | 222 | 214 |  | 5 | 214 | 222 | 214 |  | 5 | 214 | 222 | 214
 | 2 | 125 | 214 | 158 |  |  | Average 8 |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 | 123 | 214 | 233 |  | 4 | 123 | 214 | 233 |  | 4 | 123 | 214 | 233 |  | 4 | 123 | 214 | 233
 | 1 | 125 | 214 | 221 |  |  | Average 9 |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 | 147 | 125 | 125 |  | 3 | 147 | 125 | 125 |  | 3 | 147 | 125 | 125 |  | 3 | 147 | 125 | 125 |  | 3 | 147 | 125 | 125
 |  |  |  |  |  |  | Average 10 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 | 245 | 241 | 231 |  | 2 | 245 | 241 | 231 |  | 2 | 245 | 241 | 231 |  | 2 | 245 | 241 | 231 |  | 2 | 245 | 241 | 231 |  | 2 | 245 | 241 | 231
 | 1 | 125 | 125 | 145 |  |  | Average 11 |  |  |  | 1 |  |  |  |  | 1 | 124 | 125 | 169 |  | 1 | 124 | 125 | 169 |  | 1 | 124 | 125 | 169 |  | 1 | 124 | 125 | 169 |  | 1 | 124 | 125 | 169 |  | 1 | 124 | 125 | 169 |  | 1 | 124 | 125 | 169
 | 2 | 125 | 147 | 145 |  |  | Average 12
 | 3 | 125 | 125 | 211 |  |  | Average 13 |  |  |  | 1 | 125 | 125 | 145 |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1
 | 4 | 147 | 241 | 136 |  |  | Average 14 |  |  |  | 2 | 125 | 147 | 145 |  | 2 | 125 | 147 | 145 |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2
 | 5 | 158 | 169 | 214 |  |  |  |  |  |  | 3 | 125 | 125 | 211 |  | 3 | 125 | 125 | 211 |  | 3 | 125 | 125 | 211 |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3
 | 6 | 257 | 236 | 222 |  |  |  |  |  |  | 4 | 147 | 241 | 136 |  | 4 | 147 | 241 | 136 |  | 4 | 147 | 241 | 136 |  | 4 | 147 | 241 | 136 |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 5 | 158 | 169 | 214 |  | 5 | 158 | 169 | 214 |  | 5 | 158 | 169 | 214 |  | 5 | 158 | 169 | 214 |  | 5 | 158 | 169 | 214 |  | 5 |  |  |  |  | 5 |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 6 | 257 | 236 | 222 |  | 6 | 257 | 236 | 222 |  | 6 | 257 | 236 | 222 |  | 6 | 257 | 236 | 222 |  | 6 | 257 | 236 | 222 |  | 6 | 257 | 236 | 222 |  | 6 |  |  |  |  | 6