# Average Across multiple sheets

#### chacooke

##### New Member
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
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

thanks...

#### daniels012

##### Well-known Member
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?
Michael

#### texasalynn

##### Well-known Member
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?
Michael

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

#### chacooke

##### New Member
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...

Replies
0
Views
188
Replies
5
Views
85
Replies
0
Views
317
Replies
1
Views
208
Replies
3
Views
91

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.

### Which adblocker are you using?

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

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