how do i calculate the average of 30+ cells over multiple workshee

[Ariana]

how do i calculate the average of 30+ cells over multiple worksheets?

 

[Max]

how do i calculate the average of 30+ cells over multiple worksheets?

Maybe something like this suffices
Assume 3 identically structured source sheets, Sheet1/2/3

In your summary sheet
(which should not be placed within Sheet1-3)
In A1: =AVERAGE(Sheet1:Sheet3!A1)
Copy across/fill down as required to cover the range
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---

 

[Ariana]

the problem is that the worksheets are not identically structured.....

 

[Fred Smith]

OK. What is the structure? You can average a million cells if they are all
in one range. Remember, Average takes up to 30 ranges, not just cells. So if
some of your cells are together, feed them to Average as a range, rather
than separate cells.

Regards,
Fred.

 

[Harlan Grove]

the problem is that the worksheets are not identically
structured.....

....

And you're not willing to give us any hint how they are structured.

As a general issue,

=AVERAGE(Sheet1:Sheet2!B2:C5,Sheet3!X99:X110,SheetFoobar!IV65536)