# Calculate Soccer Standings

Aug 27, 2009I have a spreadsheet that tracks the score of youth soccer games. For the team standings, the teams get the following points per game based on final score.....

+6 points for a win

+1 point for a shutout

+x points goal differential no greater than 3 (so a 3-0 win would be 10 total points, as would a 4-0 or 5-0 win)

-1 point for goal differential greater than 5 (6-0 would be 9 pts, 7-0 would be 8 pts, etc)

+3 points for a tie

+0 for a loss

I've tried CSE, ARRAY, SUMIFS, OR, IF and nothing works.