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
|