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.

"Ariana" wrote in message
...
the problem is that the worksheets are not identically structured.....



"Max" wrote:

"Ariana" wrote:
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
---