Try the following...

Games:

H4, copied down:

=COUNTIF($B$3:$C$8,G4)

Wins:

I4, copied down:

=SUMPRODUCT((($B$3:$B$8=G4)*($D$3:$D$8$E$3:$E$8)) +(($C$3:$C$8=G4)*($E$3:
$E$8$D$3:$D$8)))

Losses:

J4, copied down:

=SUMPRODUCT((($B$3:$B$8=G4)*($D$3:$D$8<$E$3:$E$8)) +(($C$3:$C$8=G4)*($E$3:
$E$8<$D$3:$D$8)))

Hope this helps!

In article ,
gpktm wrote:

How can I create a league table based on results.

I want it to look like the picture and the statistics to be updated by
functions offcourse. :-)


+-------------------------------------------------------------------+
|Filename: Snap1_2.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3995 |
+-------------------------------------------------------------------+