Averages

[Karen]

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

 

[RagDyer]

Try this:

=AVERAGE(Sheet1:Sheet10!B10)
--

HTH,

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


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

 

[JE McGimpsey]

One way:

=AVERAGE(Sheet1:Sheet10!B3)

 

[JE McGimpsey]

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