Calculating Block Averages
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!
|