calculating averages

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX use Question 4
Averaging across worksheets 1
Help With A Golf League 4
taking an average of every 30 cells 4
Averages - Golf League Scoring 12
Average over non-existing numbers 7
Averages from different worksheets 4
Average weekly maximum 3

Top