Say I have the following in cells a1:d3
CHI 5 Tor 2
Det 2 NY 1
Car 3 CHI 2
I need a formula that keeps a running total of goals/game so that I have updated scoring averages by team, games are in date order.
eg, prior to the Car/Chi game, Chi would have played 1 game and scored 5 goals, so they avg 5.0 goals/game
After the 3 -2 loss to carolina, they would have played 2 games , and be averaging 3.5 goals/game.