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
---