Andrew wrote:
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

Nothing goes in the row() parens. ROW() returns the row number where the
formula is pasted.

So in C1, the formula would evaluate as

=AVERAGE(OFFSET($B$1,24*(1-1),0,24,1))
=AVERAGE(OFFSET($B$1,0,0,24,1))
=AVERAGE(B1:B24)

In C2 it would evaluate like so:
=AVERAGE(OFFSET($B$1,24*(2-1),0,24,1))
=AVERAGE(OFFSET($B$1,24,0,24,1))
=AVERAGE(B25:B49)

What we're doing is moving the reference for the average by 24 rows from
B1 each time, starting with 0 offset (24*row()-1). The 2nd "24" in the
formula says how "high" the range should be, i.e., 24 rows.

Take a look at the OFFSET function in Help for a bit more explanation.

[snipped]