Calculate Last 10 stats for MLB teams

[nicolaivinther]

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

[samba_ravi]

Can you enter result manually for at least 2 or 3 teams (Items)

[nicolaivinther]

Sure, I have done so in the attached file.
Check row 161 and 169, where I have calculated the three teams manually for the last 10 games.

MLB last 10.xlsx

[samba_ravi]

see the attached file

[nicolaivinther]

Wow, amazing..

Thanks a lot!!
I still don't get how you can do this so fast on this forum every time I ask for help.

Thank you thank you thank you