Let's assume your first eight scores are in cells A1 to H1. The average will
be =SUM(A1:H1)/8. Put this formula into H2 then copy it into I2. The new
formula will cover the range B1 to I1 automatically and will be an average of
the eight weeks starting from B1

"Golf Averages" wrote:

I would like to calculate the averages of a specific portion of data, for
instance calculating golf averages of the last 8 scores of a data list of 20,
but with each score that is posted each week I only want to calculate the
average for the last 8 weeks.