Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGE cells on another worksheet when the range is calculated
I am trying to average a range of cells on the main worksheet of my workbook,
but the cells to be averaged are on another worksheet in my workbook where the range of cells to be averaged is calculated from an input cell on the main worksheet |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGE cells on another worksheet when the range is calculated
Huh?? That is a very confusing paragraph.
I think you want something like this: =AVERAGE(OFFSET('Some sheet'!A1,0,0,5,0)) Where 5 is telling the formula to average cells A1:A5. By placing different variables within the OFFSET function you can control which cells you want to average. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "SALeng" wrote: I am trying to average a range of cells on the main worksheet of my workbook, but the cells to be averaged are on another worksheet in my workbook where the range of cells to be averaged is calculated from an input cell on the main worksheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I average a range which also contains empty cells | Excel Discussion (Misc queries) | |||
Calculate Average with 'x' in Range of Cells | Excel Worksheet Functions | |||
average range of cells with zero and blanks | Excel Discussion (Misc queries) | |||
Average Selected Cells From a Range | Excel Worksheet Functions | |||
How do I average a range of cells when one cell contains #N/A | Excel Discussion (Misc queries) |