Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Average over many worksheets
I have 19 worksheets, all set up with the same column designations but with a
varying number of rows in use. I need to calculate an average for all the numerical values in Column C on all the worksheets. Currently the most rows in use on a worksheet is 1987 and the least is 67. As a quick solution , I copied and pasted them all into one column on a new worksheet and averaged at the bottom but there must be a far better way. Thanks Pepper |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Average over many worksheets
If you don't have any other numbers not to be included in column C you can
use =AVERAGE(First:Last!C:C) and if you create new sheets than you should literally create 2 dummy sheets one perhaps called First and one call Last and then you can insert any new sheet in-between them and you won't have to change the formula -- Regards, Peo Sjoblom "Pepper" wrote in message ... I have 19 worksheets, all set up with the same column designations but with a varying number of rows in use. I need to calculate an average for all the numerical values in Column C on all the worksheets. Currently the most rows in use on a worksheet is 1987 and the least is 67. As a quick solution , I copied and pasted them all into one column on a new worksheet and averaged at the bottom but there must be a far better way. Thanks Pepper |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Average | Excel Discussion (Misc queries) | |||
Calculating Average | Excel Worksheet Functions | |||
Calculating an average with conditions. | Excel Discussion (Misc queries) | |||
Calculating the average | Excel Discussion (Misc queries) | |||
Function Key for Calculating Average? | Excel Worksheet Functions |