Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the average of 30+ cells over multiple workshee
how do i calculate the average of 30+ cells over multiple worksheets?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the average of 30+ cells over multiple workshee
"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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the average of 30+ cells over multiple work
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the average of 30+ cells over multiple work
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the average of 30+ cells over multiple work
Ariana wrote...
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,Sheet Foobar!IV65536) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I would like to set a footer that is the same on multiple workshee | Excel Discussion (Misc queries) | |||
Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
Calculate Average Accross Multiple Worksheets | Excel Discussion (Misc queries) | |||
How do I calculate an average of the last 5 nonblank cells in a row? | Excel Worksheet Functions | |||
Why are there multiple instances of same person on shared workshee | Excel Discussion (Misc queries) |