Calculating Number of sets and wins in tennis match table

[remalguy]

Hello all,
I need help in the following.
I have a sheet with players and the results of their game (in same line)
I want to automatically add 1 point if the player won the match (in the points column) and add the number of sets the player won or lost

some tennis rules about winning or losing :
You win the set if you reach 6 (and opponent has 4 or less) or if you reach 7
if you win the tiebreak it's like you win a set
you win the match if you win 2 sets
If you win the match you take 1 point, if you lose you get 0

		points		sets +	sets -		games +	games -		set 1	set 2	tie break
Player A		1		2	1		9	11		7	5	2	6	10	8
Player B		0		0	2		11	14		6	7	5	7
Player C		1		2	0		12	3		6	2	6	1
Player D										6	1	7	6
Player E										7	6	4	6	12	10

<colgroup><col><col><col span="5"><col><col><col span="7"></colgroup><tbody>
</tbody>

Thanks all in advance,
Cheers

 

[steve the fish]

B2: =--(C2>D2)
C2: =SUM((G2>H2)+(I2>J2)+(K2>L2))
D2: =SUM((H2>G2)+(J2>I2)+(L2>K2))

Those should work for that.

 

[remalguy]

Super thanks Steve !!!!!!!!

 

[remalguy]

In need of help again....
If I have to add stats of match2, in the same format as match1 I have in the example (set1, set2, tiebreak) next of it, how the formula for B2 must be ?


Thanks for your efforts