Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating weighted averages | Excel Discussion (Misc queries) | |||
Calculating averages excluding outliers...a question | Excel Worksheet Functions | |||
Calculating basic averages...a question | Excel Worksheet Functions | |||
calculating averages | Excel Discussion (Misc queries) | |||
calculating averages | Excel Worksheet Functions |