Averages
 

I have about 10 sheet tabs and in cell B3 of each sheet
tab I have an average. I want to create a summary sheet
that will average all of the averages from each 10 sheet
tabs. What operator separates each sheet tab and cell
reference?

Thank you

Try this:

=AVERAGE(Sheet1:Sheet10!B10)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Karen" wrote in message
...
I have about 10 sheet tabs and in cell B3 of each sheet
tab I have an average. I want to create a summary sheet
that will average all of the averages from each 10 sheet
tabs. What operator separates each sheet tab and cell
reference?

Thank you

One way:

=AVERAGE(Sheet1:Sheet10!B3)

In article ,
"Karen" wrote:

I have about 10 sheet tabs and in cell B3 of each sheet
tab I have an average. I want to create a summary sheet
that will average all of the averages from each 10 sheet
tabs. What operator separates each sheet tab and cell
reference?

Thank you

Note that this solution only works if the 10 sheets are contiguous,
Sheet1 is on the left, and Sheet10 is on the right.


In article ,
JE McGimpsey wrote:

One way:

=AVERAGE(Sheet1:Sheet10!B3)

In article ,
"Karen" wrote:

I have about 10 sheet tabs and in cell B3 of each sheet
tab I have an average. I want to create a summary sheet
that will average all of the averages from each 10 sheet
tabs. What operator separates each sheet tab and cell
reference?

Thank you