Thread: Averages
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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