Prev: Subtotals on imported data
Next: Excel 2007 with two windows in Windows 7
From: SALeng on 15 Jan 2010 09:20
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
From: Luke M on 15 Jan 2010 10:00
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
 | 
Pages: 1
Prev: Subtotals on imported data
Next: Excel 2007 with two windows in Windows 7