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