Hey Everyone
I have an excel doc that has 20 sheets on it, all the same exact layout. On these two sheets, they are broken into two different "teams". I was wondering if anyone could help me out in taking the averages across these different sheets. Below is an example...
Sheets are labeled by the team names (i.e. Davis, Jones, Smith, Cooke, etc...)
I'm looking to create an summary tab in the front of the doc for the different group (Davis and Jones are one group and Smith and Cooke are another team).
on the summary sheet, I want to get the average of everyone's scores in group 1 in one cell and same for group 2
In a perfect world, I would love to have the summary information on an altogether different worksheet, but pretty sure that is going to be way above my abilities so I was going to start with getting the summaries. One of the problems that I run into is that not all of the teams work at the same pace so out of the 10 teams, maybe only 5 of them have an actual value in o90.
I have downloaded the threed add-in, but pretty much a dear in headlights trying to figure it out...any help would be much appreciated.
I have an excel doc that has 20 sheets on it, all the same exact layout. On these two sheets, they are broken into two different "teams". I was wondering if anyone could help me out in taking the averages across these different sheets. Below is an example...
Sheets are labeled by the team names (i.e. Davis, Jones, Smith, Cooke, etc...)
I'm looking to create an summary tab in the front of the doc for the different group (Davis and Jones are one group and Smith and Cooke are another team).
on the summary sheet, I want to get the average of everyone's scores in group 1 in one cell and same for group 2
In a perfect world, I would love to have the summary information on an altogether different worksheet, but pretty sure that is going to be way above my abilities so I was going to start with getting the summaries. One of the problems that I run into is that not all of the teams work at the same pace so out of the 10 teams, maybe only 5 of them have an actual value in o90.
I have downloaded the threed add-in, but pretty much a dear in headlights trying to figure it out...any help would be much appreciated.