Average every x cells
 

I am trying to average data in a column from every 4 cells together. For
example, if data is in column A, then average A1:A4, A5:8,... Then put the
results in contiguous cells in column B. B1 would have average of A1:A4, B2
average of A5:A8, ...

Thanks in advance

Average every x cells
 

In article ,
Wox wrote:

I am trying to average data in a column from every 4 cells together. For
example, if data is in column A, then average A1:A4, A5:8,... Then put the
results in contiguous cells in column B. B1 would have average of A1:A4, B2
average of A5:A8, ...

Thanks in advance

Try...

B1, copied down:

=AVERAGE(INDEX($A$1:$A$100,ROWS(B$1:B1)*4-4+1):INDEX($A$1:$A$100,ROWS(B$1
:B1)*4))

--
Domenic
http://www.xl-central.com

Average every x cells
 

Thanks Domenic, this works great.

Thanks tons

"Domenic" wrote:

In article ,
Wox wrote:

I am trying to average data in a column from every 4 cells together. For
example, if data is in column A, then average A1:A4, A5:8,... Then put the
results in contiguous cells in column B. B1 would have average of A1:A4, B2
average of A5:A8, ...

Thanks in advance

Try...

B1, copied down:

=AVERAGE(INDEX($A$1:$A$100,ROWS(B$1:B1)*4-4+1):INDEX($A$1:$A$100,ROWS(B$1
:B1)*4))

--
Domenic
http://www.xl-central.com

Average every x cells
 

Here's another one. More compact but volatile (will recalculate any time a
calculation takes place).

Entered in B1 and copied down:

=AVERAGE(OFFSET(A$1,ROWS(B$1:B1)*4-4,,4))

--
Biff
Microsoft Excel MVP


"Wox" wrote in message
...
I am trying to average data in a column from every 4 cells together. For
example, if data is in column A, then average A1:A4, A5:8,... Then put the
results in contiguous cells in column B. B1 would have average of A1:A4,
B2
average of A5:A8, ...

Thanks in advance