Microsoft Excel - Trying to get Team averages for each week

Asked By Stephen P on 01-Oct-13 12:30 PM
I have a workbook with 17 sheets, each sheet for a different week, titled week 1, week 2, etc.
Each week has teams that are playing against each other each week. I also have a sheet with totals, and I am looking to set up a formula that will give me an average for each week.
Thank you for any assistance.
Pichart Y. replied to Stephen P on 01-Oct-13 09:32 PM
Hi Stephen P,

There are many easy ways to do, depends on you spreadsheet structure. Attach your sample file with 3-4 sheets to explain your work, then will be easy for suggestion.

Pichart Y.
Stephen P replied to Pichart Y. on 08-Oct-13 12:36 PM
Prichart,

I can't find the file when I go to browse,

so I copied part of a sheet this is from week 1

Ravens 27 76
Broncos Win 49 76
Dolphins Win 23 33
Browns 10 33
Vikings 24 58
Lions Win 34 58
Raiders 17 38
Colts Win 21 38
Chiefs Win 28 30
Jaguars 2 30
Buccaneers 17 35
Jets Win 18 35
Falcons 17 40
Saints Win 23 40
Titans Win 16 25
Steelers 9 25
Bengals 21 45
Bears Win 24 45
Seahawks Win 12 19
Panthers 7 19
Patriots Win 23 44
Bills 21 44
Packers 28 62
49ers Win 34 62
Cardinals 24 51
Rams Win 27 51
Giants 31 67
Cowboys Win 36 67
Eagles Win 33 60
Redskins 27 60
Texans Win 31 59
Chargers 28 59
M. Sullivan replied to Stephen P on 10-Oct-13 09:34 AM
Use the Average function, i.e., Average(a1:a9) to average the scores. The formula can be easily copied or dragged to where it is needed.