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