calculating valuses from all sheets

[Deepak]

I have single workbook with 31 sheets on it (all sheets has diff. names on it)

all the sheets have some values in A8 & A9 (maintained position)

what i want is on the first sheet in cells A8 and A9 I need the average from
all the other sheets from cells A8 & A9

Sheet 1 = A
Sheet 2 = B
Sheet 3 = C
Sheet 4 = D

so Cells A8 & A9 in "Sheet A" - should have the average from "Sheet B" A8 &
A9, "Sheet C" A8 & A9, "Sheet D" A8 & A9,

I hope i didnt confuse

thanks in advance

 

[Mike H]

Hi,

Try this.
Make 2 sheets. The first named Start(Before Sheet1) and the second named
End(After Sheet31).
In the cell where you need the average write this formula.

=AVERAGE(Start:End!A8)

It will average the numbers in A8 for every sheet between the 2 dummy sheets
which to keep the job tidy can be hidden.

Mike

 

[Gord Dibben]

With unique sheetnames the easiest method is to insert a new sheet at
beginning.........name it Start

Insert a new sheet at the end.............name it End

In original first sheet(now second) =AVERAGE(Start:End!A8:A9)

If you insert more sheets, insert them between Start and End


Gord Dibben MS Excel MVP