Creating a league table based on results

[gpktm]

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 |
+-------------------------------------------------------------------+

 

[Domenic]

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!

 

[gpktm]

Thanks, that helped some bit but there are some problems in th
following: It not accepts the function in H4 cell. And how about th
draws

 

[Domenic]

It not accepts the function in H4 cell.

That's probably because your version of Excel uses a semi-colon as a
separator instead of a comma. Try...

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

And how about the draws?

=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!