Creating a league table based on results
 

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

--
gpktm
------------------------------------------------------------------------
gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538
View this thread: http://www.excelforum.com/showthread...hreadid=482532

Creating a league table based on results
 

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

Creating a league table based on results
 

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


--
gpktm
------------------------------------------------------------------------
gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538
View this thread: http://www.excelforum.com/showthread...hreadid=482532

Creating a league table based on results
 

In article ,
gpktm wrote:

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!