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

Average across worksheets ignoring zero 2
How do I calculate a weighted average and exclude the empthy cells 2
Excel Average dates help 0
Average except for something lower... 2
30 Day Moving Average Ignoring Blank Cells 2
Average more than 30 numeric arguments 15
Problem using average or sum formulas 3
Average without Hidden Cells 4

Top