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

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