Hello.
The following sheet shows 4 weeks of Championship football results. I want the following points to appear in column B.
Taking Barnsley as an example, in week 1 they achieved 1 point; in week 2, 5 points; in week 3, 1 point and in week 4, 3 points. Total 10 points
Watford's points are, week 1, 1 point; week 2, 3 points; week 3, -2 points; and in week 4, 2 points. Total 4 points.
So, I want column B to show all points won for the previous 4 matches played, and columns O and P to show the relevant points won depending on the fixtures.
Home win with 1 goal difference: 1 point
Home win with 2 goals difference: 3 points
Home win with 3 and more than 3 goals difference: 6 points
Away win with 1 goal difference: 2 points
Away win with 2 goals difference: 5 points
Away win with 3 and more than 3 goals difference: 7 points
Home draw: 0 points
Away draw: 1 point
Home defeat: -4 points (negative)
Away defeat: -2 points (negative)
Thank you.
https://docs.google.com/spreadsheets...it?usp=sharing
Bookmarks