I posted this yesterday but when I pasted everyones versions of their formula
nothing worked. Here is what I have tried:
=AVERAGE(OFFSET($B$1,24*(ROW()-1),0,24,1)). If I want 24 rows in a column
do what do I put in the ROW ( ) parens. Is this right? See below for
explanation of issue




I have a column of data where I need to select a group of X number of cells
each time and obtain an average. When I copy the formula down it only copies
the formula with one additional space down, but I want it to jump over the
cells that have already been averaged. Example formuala is: Average(B1:B5),
when copied down it goes (B2:B6), but I want (B6:10). Im sure this is easy
but I dont know the shortcut.