bpeltzer wrote...
=AVERAGE(OFFSET($A$1,0,0,A8,1)). This will start in A1 and average the
number of rows indicated in A8.
....

Variation on this using nonvolatile functions.

=AVERAGE($A$1:INDEX($A:$A,A8))