Formula to Count number of wins between two players

[sankaman]

I have a table in which I want to count the number of matches a certain player has won and loss. This is what I have:

What I want is a formula that returns the number of times Alex has won and lost against all other players and so on with every player.

I was thinking of COUNTIF but I can seem to get it to work.

 

[sankaman]

What about this then?

24 04 06.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1
2		W	L	W	L	W	L	W	L	W	L	W	L	W	L	W	L	W	L	W	L			W	L	Pts
3	Alex			3	2	3	2	0	4	4	2	3	1	2	1	4	3	1	3	0	4			6	3	-2
WL

Cell Formulas
Range	Formula
X3	X3	=SUMPRODUCT((B3:T3>C3:U3)*(B$2:T$2="W"))
Y3	Y3	=COUNT(B3:U3)/2-X3
Z3	Z3	=SUMIF(B$2:U$2,"W",B3:U3)-SUMIF(B$2:U$2,"L",B3:U3)

Thank you, that did the trick.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.