skipping columns

I realize this has been posted before, but I can't seem to find it. Suppose
I have data in columns E, L, S,etc., in other words, ever 7th column. My row
range is 3:650. How can I average these columns in adjacent cells, i.e. the
average of E3:E650 in A700, the average of L3:L650 in B700, and so on? I
know it has something to do with INDIRECT and OFFSET, but can't seem to make
heads or tails out of it. In addition, will this kind of manipulation work
with array formulae?

Wazooli

On cell A700 type
=AVERAGE(OFFSET($E$3,0,COLUMN()*7-7,648))
aand copy it across B700 and so on

"Wazooli" <[email protected]> wrote in message
news:[email protected]...
>I realize this has been posted before, but I can't seem to find it.
>Suppose
> I have data in columns E, L, S,etc., in other words, ever 7th column. My
> row
> range is 3:650. How can I average these columns in adjacent cells, i.e.
> the
> average of E3:E650 in A700, the average of L3:L650 in B700, and so on? I
> know it has something to do with INDIRECT and OFFSET, but can't seem to
> make
> heads or tails out of it. In addition, will this kind of manipulation
> work
> with array formulae?
>
> Wazooli

Thanks - I'll try that

wazooli

"N Harkawat" wrote:

> On cell A700 type
> =AVERAGE(OFFSET($E$3,0,COLUMN()*7-7,648))
> aand copy it across B700 and so on
>
> "Wazooli" <[email protected]> wrote in message
> news:[email protected]...
> >I realize this has been posted before, but I can't seem to find it.
> >Suppose
> > I have data in columns E, L, S,etc., in other words, ever 7th column. My
> > row
> > range is 3:650. How can I average these columns in adjacent cells, i.e.
> > the
> > average of E3:E650 in A700, the average of L3:L650 in B700, and so on? I
> > know it has something to do with INDIRECT and OFFSET, but can't seem to
> > make
> > heads or tails out of it. In addition, will this kind of manipulation
> > work
> > with array formulae?
> >
> > Wazooli
>
>
>