Hi
I have an issue in excel. I want to calculate some stats for baseball teams in their last 10 games.
I want excel to find the last ten games where the team has played a game, and take the sum of their stats ABS in these 10 games.
I came close earlier, but I just can't figure it out.
I have attached the sheet. So the F column has to show the sum of the ABS for the away team last 10 games played.
Please notice that the teams stats is shown in either F or G column. It all depends on whether the team played at home or away in the given game
I want this data to be shown for all teams in each game (as long as they have played 10 games ofc.
I hope it is possible to fix. It is okay to add more cells to make the calculation if it is needed.
Attachment 361553 - UPDATED WITH EXAMPLE IN ROW 161 AND 169
Best regards
Nicolai
Bookmarks