Average every x cells

[Wox]

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

 

[Domenic]

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))

 

[Wox]

Thanks Domenic, this works great.

Thanks tons

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))

 

[T. Valko]

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))