I have what I hope is a relatively easy problem. It's basic stats compilation. A single player may play multiple years and multiple games in each year. After each game, I will enter the game's stats for each player, in this example only hits. What I'm hoping for is for excel to consolidate automatically each player's games into a single year entry, and then consolidate a player's multiple years into one total sum for each player. in short, I add a game's stats for a player, and the player's single year and all-years total automatically updates.
I can use the consolidation feature to manually do this, but that wouldn't be feasible if I'm adding an entire team's stats after each game and wanting the single year and all-years totals to update in real time. I hope someone smarter than me can make quick work of this problem.
