Prev: zero value in cell
Next: Yes - No Interactive Text Box
From: Wendy Akers Wendy on 28 May 2010 16:30
I add a column every week to my work sheet and want the formula to always
calculate the current 5 column range.


From: Glenn on 28 May 2010 16:45
Wendy Akers wrote:
> I add a column every week to my work sheet and want the formula to always
> calculate the current 5 column range.
>
>

Add a column WHERE?

What "formula"?

Where is the "current 5 column range"?
From: Ashish Mathur on 28 May 2010 19:14
Hi,

Let's say your data is in range C3:H3. In cell K3, enter the following
array formula (Ctrl+Shift+Enter) to get the average

=AVERAGE(OFFSET(INDIRECT(ADDRESS(3,MAX(ISNUMBER(C3:J3)*COLUMN(C3:J3))+1)),0,-5,1,5))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Wendy Akers" <Wendy Akers(a)discussions.microsoft.com> wrote in message
news:6BB10794-0B64-4768-B2F8-F5234474698F(a)microsoft.com...
> I add a column every week to my work sheet and want the formula to always
> calculate the current 5 column range.
>
>
 | 
Pages: 1
Prev: zero value in cell
Next: Yes - No Interactive Text Box