A
Ariana
how do i calculate the average of 30+ cells over multiple worksheets?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
Ariana said: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
---
A
Ariana
the problem is that the worksheets are not identically structured.....
F
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.
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.
H
Harlan Grove
....Ariana said: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)