Calculating Block Averages
=AVERAGE(OFFSET($A$1,(ROW(A1)-1)*6,0,5,1))
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"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!
|