in the second one and copied down
=AVERAGE(INDIRECT("A"&ROW(A1)*6&":A"&ROW(A1)*10))

--
Don Guillett
SalesAid Software

"M.G." wrote in message
...
Hi,

I'm pulling my hair out over this one. I want to calculate block averages.
For instance:

A1 AVERAGE(A1:A5)
A2 AVERAGE(A6:A10)
A3 AVERAGE(A11:A15)
etc....

The problem is that I cannot get Excel to recognize the pattern when I try
to pull down the column and populate the rest of the cells. For example,
in
the 4th cell down, Excel will fill in "AVERAGE(A12:A16)" when I want
"AVERAGE(A16:A20)". I tried manually typing in more formulas below to see
if
Excel would eventually catch on to the pattern, but it does not. There
must
be a way to do this!

Thanks!