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
|