Need help tracking volleyball stats over a season

Hi! First post here--found the forum by googling "Excel forums" and here we are!

I know basic Excel. I use it rarely so I usually have to investigate how to do various things when I need to, but typically have kept to basic sums, etc.

Here is what I'd like to do:

I have a high school girls volleyball team. I'd like to list their names in a column followed by jersey number. I'd then like to have columns headed by individual stats... serves, missed serves, kills, digs, dives, etc. Simple enough. I'd like to use a sheet per game, so if they play a three game match, I'd track stats for each game. (As I write this, perhaps I'll make a sheet per match, but three columns under each stat representing each game).

I would then like a sheet where totals and averages end up. I've never done any Excel stats/sums/percentages across multiple sheets. So lets say Sally has played in every game, I'd like a sheet where her stats automatically accumulate and possibly average (like percent missed serves).

Now. Would it be best to do this within a single file? Each sheet could either represent a match or a game? I'm planning on printing blank copies for my manager to pencil tally during the game and enter during practice.

Any help or advice would be appreciated. If a similar situation is already written up in a tutorial somewhere a link would be great. Thanks!

Thanks for the replies and help. I may go with something similar to what you guys developed. However, I was hoping to learn how to do something more complex. Like this: http://www.straightfromdehart.com/vo...yball-coaches/ Except I'd like to learn how to create it on my own because there are different stats I'd like to track.

Originally Posted by CoachB

Thanks for the replies and help. I may go with something similar to what you guys developed. However, I was hoping to learn how to do something more complex. Like this: http://www.straightfromdehart.com/vo...yball-coaches/ Except I'd like to learn how to create it on my own because there are different stats I'd like to track.

Hi,
optional - and a more comprehensive - solution for your needs could be full version of UltimateVolleyStats, if you own some tablet or smartphone using Android. Full app and free demo are available at https://play.google.com/store/search...ystats&c=apps/ .

How do you get the cells to increase numbers when you click on them? That is a feature I want to learn how to do!

Thanks.