Please help
Col A Col B Col C Col D Col E Col F
Team A Team B 3 2 Team A 1
Team C Team D 2 1 Team B 1
Team A Team C 0 0 Team C 1
Team D Team B 1 2 Team D 1
Team D Team A 2 1
Team B Team C

The above is a fixture & result table of a €˜Round Robin soccer competition
where columns A&B are the fixtures & column C & D are the scores of the
respective games. Column E shows the teams in a league table format and
column F is the number of wins for each team. What I need is a formula to
calculate the number of wins for each team bearing in mind they maybe either
the home or away team (either column A or Column B)
Thanks in advance
Al