Average Across multiple sheets

chacooke

New Member
Joined
Oct 16, 2006
Messages
7
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.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
you can average across sheets if they are in the same layout. The easiest way is to create a sheet in the front "First", then create another sheet at the end "Last" Then add the formula on the sheet with the summaries:

Code:
=AVERAGE(First:Last!A1)

change A1 to where your cell data is
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
texaslynn,
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.

Does this work to solve this issue?

In other words if there are zeros, they would not be averaged?

Just curious? :confused:
Michael
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
texaslynn,
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.

Does this work to solve this issue?

In other words if there are zeros, they would not be averaged?

Just curious? :confused:
Michael

I don't believe it does - but you probably already knew that
 

chacooke

New Member
Joined
Oct 16, 2006
Messages
7
It actually did, it did not average in the zero's...I did a quick check to do a manual average and it didn't add in the blanks...
 

Forum statistics

Threads
1,136,345
Messages
5,675,223
Members
419,553
Latest member
hanahass

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top