Averageif or Averageifs not sure on which one to use

[mt45]

First thank you for clicking on the thread to help solve this problem!

I am trying to average the difference between scores of every game during the 2006 NFL season for each team. Below is the excel file with all the data. Only the first three weeks are included but that should be plenty of data. (ill go back and fill the rest of the data if and when someone is able to help me) Ill also add a PDF file for what I am trying to accomplish with the data so if anyone could help with that also it would mean the world. Thank you in advance as I'm sure most of you are very busy.

[zbor]

Hi mt45, wellcome to the forum...

Please, rename your title according to the rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.