Sorry I misunderstood your previous post.
What I am trying to do is take the average of all the opponents value they have played. So the formulas in the column labeled opp value is using vlookup to find the diffvalue of each team in that row
The intention is to add strength of schedule into the overall value of the team
I don't understand why it has worked for 12+ weeks but now doesn't work with this weeks data added in
Bookmarks