Spreadsheet: 221201d1363408531-function-that-will-calculate-the-running-average-ofthe-last-3-in-a-set-of-conditional-data-template3
Sheet: Template

Team 1
Offensive Stats |  |  |  |  |  |  |  |  |  |  |  |  |  | Defensive Stats
Player | MIN | Game | Location |  |  |  | REB | AST | STL | BLK | TO | PF | PTS | POS | MIN | Game | Location |  |  |  | REB | AST | STL | BLK | TO | PF | +/- | PTS
A | 28 | 1 | H |  |  |  | 11 | 1 | 0 | 0 | 1 | 2 | 15 | PG | 29 | 1 | H |  |  |  | 2 | 1 | 1 | 0 | 0 | 3 | 12 | 6
B | 41 | 1 | H |  |  |  | 5 | 5 | 2 | 0 | 0 | 3 | 23 | SF | 29 | 1 | H |  |  |  | 10 | 3 | 2 | 0 | 0 | 2 | 12 | 26
C | 32 | 1 | H |  |  |  | 12 | 2 | 0 | 2 | 5 | 4 | 9 | C | 37 | 1 | H |  |  |  | 10 | 1 | 0 | 3 | 1 | 3 | 15 | 19
D | 44 | 1 | H |  |  |  | 7 | 13 | 0 | 0 | 4 | 4 | 20 | PF | 36 | 1 | H |  |  |  | 1 | 11 | 3 | 0 | 1 | 3 | 11 | 8
E | 24 | 1 | H |  |  |  | 1 | 1 | 0 | 0 | 1 | 5 | 11 | PG | 35 | 1 | H |  |  |  | 3 | 4 | 2 | 1 | 4 | 3 | -6 | 29
F | 8 | 1 | H |  |  |  | 1 | 0 | 0 | 0 | 0 | 1 | 2 | SG | 11 | 1 | H |  |  |  | 3 | 0 | 0 | 0 | 1 | 1 | -2 | 0
G | 23 | 1 | H |  |  |  | 3 | 0 | 1 | 0 | 1 | 0 | 3 | C | 19 | 1 | H |  |  |  | 5 | 1 | 0 | 1 | 0 | 1 | 1 | 10
H | 25 | 1 | H |  |  |  | 0 | 1 | 1 | 0 | 3 | 3 | 8 | SG | 6 | 1 | H |  |  |  | 0 | 1 | 0 | 0 | 1 | 2 | 5 | 3
I | 16 | 1 | H |  |  |  | 1 | 1 | 0 | 0 | 0 | 1 | 16 | PF | 31 | 1 | H |  |  |  | 2 | 2 | 0 | 0 | 0 | 1 | 9 | 19
C | 25 | 2 | A |  |  |  | 2 | 1 | 1 | 0 | 0 | 3 | 6 | PG | 7 | 1 | H |  |  |  | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 0
B | 38 | 2 | A |  |  |  | 10 | 3 | 2 | 0 | 0 | 2 | 26 | SF | 38 | 2 | A |  |  |  | 7 | 2 | 0 | 0 | 2 | 2 | 15 | 9
H | 31 | 2 | A |  |  |  | 10 | 1 | 0 | 3 | 1 | 3 | 19 | SG | 32 | 2 | A |  |  |  | 5 | 3 | 1 | 0 | 2 | 0 | 17 | 25
A | 40 | 2 | A |  |  |  | 1 | 11 | 3 | 0 | 1 | 3 | 8 | PG | 40 | 2 | A |  |  |  | 2 | 1 | 1 | 5 | 1 | 2 | 19 | 10
D | 28 | 2 | A |  |  |  | 3 | 4 | 2 | 1 | 4 | 3 | 29 | C | 35 | 2 | A |  |  |  | 3 | 5 | 1 | 0 | 1 | 1 | 15 | 11
I | 12 | 2 | A |  |  |  | 3 | 0 | 0 | 0 | 1 | 1 | 0 | SF | 9 | 2 | A |  |  |  | 6 | 3 | 0 | 0 | 1 | 3 | 20 | 10
G | 21 | 2 | A |  |  |  | 5 | 1 | 0 | 1 | 0 | 1 | 10 | PG | 3 | 2 | A |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0
E | 19 | 2 | A |  |  |  | 0 | 1 | 0 | 0 | 1 | 2 | 3 | SG | 10 | 2 | A |  |  |  | 6 | 2 | 0 | 1 | 0 | 2 | 8 | 18
F | 12 | 2 | A |  |  |  | 2 | 2 | 0 | 0 | 0 | 1 | 19 | PF | 6 | 2 | A |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 6 | 2
H | 32 | 3 | A |  |  |  | 7 | 1 | 0 | 2 | 1 | 4 | 12 | SG | 5 | 2 | A |  |  |  | 2 | 5 | 1 | 1 | 0 | 0 | 6 | 5
C | 35 | 3 | A |  |  |  | 6 | 7 | 0 | 1 | 2 | 0 | 19 | PF | 2 | 2 | A |  |  |  | 2 | 1 | 0 | 0 | 0 | 0 | 6 | 7
A | 40 | 3 | A |  |  |  | 5 | 1 | 1 | 0 | 2 | 2 | 5 | PG | 23 | 2 | A |  |  |  | 6 | 1 | 0 | 2 | 2 | 3 | 7 | 2
E | 19 | 3 | A |  |  |  | 3 | 5 | 1 | 0 | 1 | 1 | 11 | PF | 3 | 3 | A |  |  |  | 3 | 8 | 0 | 0 | 1 | 3 | 14 | 14
D | 21 | 3 | A |  |  |  | 4 | 1 | 0 | 1 | 2 | 3 | 13 | PG | 26 | 3 | A |  |  |  | 1 | 2 | 1 | 0 | 2 | 3 | 9 | 2
B | 35 | 3 | A |  |  |  | 4 | 2 | 0 | 0 | 0 | 0 | 4 | PG | 27 | 3 | A |  |  |  | 8 | 3 | 0 | 0 | 3 | 3 | -13 | 18
F | 28 | 3 | A |  |  |  | 0 | 2 | 1 | 0 | 0 | 0 | 0 | SF | 27 | 3 | A |  |  |  | 6 | 0 | 0 | 0 | 1 | 1 | -3 | 16
I | 16 | 3 | A |  |  |  | 4 | 0 | 0 | 1 | 0 | 0 | 6 | SG | 22 | 3 | A |  |  |  | 3 | 3 | 0 | 1 | 0 | 3 | 4 | 9
G | 12 | 3 | A |  |  |  | 8 | 0 | 1 | 3 | 1 | 5 | 8 | C | 28 | 3 | A |  |  |  | 3 | 3 | 2 | 0 | 2 | 0 | -13 | 13
I | 35 | 4 | H |  |  |  | 3 | 3 | 1 | 0 | 0 | 0 | 13 | PF | 3 | 3 | A |  |  |  | 3 | 2 | 0 | 1 | 0 | 2 | -6 | 10
A | 41 | 4 | H |  |  |  | 3 | 5 | 0 | 0 | 0 | 4 | 9 | PG | 20 | 3 | A |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | -26 | 6
C | 25 | 4 | H |  |  |  | 2 | 1 | 0 | 0 | 2 | 0 | 11 | C | 6 | 3 | A |  |  |  | 1 | 3 | 1 | 0 | 0 | 2 | -12 | 5
B | 19 | 4 | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 5 | SG | 15 | 3 | A |  |  |  | 4 | 0 | 0 | 0 | 1 | 1 | 3 | 2
H | 12 | 4 | H |  |  |  | 5 | 0 | 0 | 2 | 1 | 2 | 4 | SF | 5 | 4 | H |  |  |  | 0 | 3 | 2 | 0 | 0 | 1 | -19 | 5
G | 8 | 4 | H |  |  |  | 3 | 2 | 1 | 1 | 0 | 1 | 2 | PG | 14 | 4 | H |  |  |  | 0 | 2 | 0 | 0 | 1 | 1 | -23 | 6
F | 36 | 4 | H |  |  |  | 0 | 2 | 0 | 0 | 1 | 1 | 5 | C | 26 | 4 | H |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | -11 | 0
D | 28 | 4 | H |  |  |  | 5 | 4 | 0 | 1 | 2 | 2 | 11 | SG | 20 | 4 | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -11 | 0
E | 32 | 4 | H |  |  |  | 5 | 5 | 0 | 0 | 0 | 2 | 21 | SF | 24 | 4 | H |  |  |  | 0 | 3 | 0 | 1 | 4 | 2 | -20 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SG | 14 | 4 | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | -3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PF | 20 | 4 | H |  |  |  | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PF | 8 | 4 | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PG | 15 | 4 | H |  |  |  | 1 | 6 | 2 | 0 | 3 | 0 | 19 | 20
Player | MIN | Averages |  |  |  |  | REB | AST | STL | BLK | TO | PF | PTS | POS | MIN | Averages |  |  |  |  | REB | AST | STL | BLK | TO | PF | +/- | PTS
A |  | Season Home |  |  |  |  |  |  |  |  |  |  |  | PG |  | Season Home
 |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total
B |  | Season Home |  |  |  |  |  |  |  |  |  |  |  | SG |  | Season Home
 |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total
C |  | Season Home |  |  |  |  |  |  |  |  |  |  |  | SF |  | Season Home
 |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total
D |  | Season Home |  |  |  |  |  |  |  |  |  |  |  | PF |  | Season Home
 |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total
 |  |  |  |  |  |  |  | Hi! I have been tasked with keeping stats for a basketball league. I have formulas that will calculate season running averages for each player for both home and road games. For example, cell B46 is the running average of minutes played during home games for player [NAME] What I am trying to calculate is the running average of minutes played for player A in the last 3 games only. The formula will go in cell B48. Similarly, on the opposite side of the spreadsheet are defensive stats. Cell P46 is the running average of the number of minutes played by the opposing teams point guards (PG). I have calculated the running average for the entire season for home/road games, but need the running average for all PGs in the last 3 games played only. That formula will go in cell P48. Please help!!!! I have uploaded the basic template, but the sheet will be expanded to account for all games, players and positions for multiple teams, so manually imputing an average function for each is not an option.  Just FYI, I have never used a pivot table, and would prefer not to.