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

M

Max

Ariana said:
how do i calculate the average of 30+ cells over multiple worksheets?
Click to expand...

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

Harlan Grove

Ariana said:
the problem is that the worksheets are not identically
structured.....
Click to expand...
....

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
How do I calculate a weighted average and exclude the empthy cells 2
calculate average values for 100 records in the shortest way? 5
calculating payment terms "End of Month +30". 1
Averaging feet and inches (not decimal feet) 4
Average more than 30 numeric arguments 15
Average across worksheets ignoring zero 2
Trying to find additional ranges outside of min, max, and average 2

Top