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


[TABLE="width: 1068"]
<colgroup><col><col><col span="5"><col><col><col span="7"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]points[/TD]
[TD] [/TD]
[TD]sets +[/TD]
[TD]sets -[/TD]
[TD] [/TD]
[TD]games +[/TD]
[TD]games -[/TD]
[TD] [/TD]
[TD="colspan: 2"]set 1[/TD]
[TD="colspan: 2"]set 2[/TD]
[TD="colspan: 2"]tie break[/TD]
[/TR]
[TR]
[TD]Player A[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]9[/TD]
[TD]11[/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD]10[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Player B[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]11[/TD]
[TD]14[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Player C[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]12[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Player D[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Player E[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]12[/TD]
[TD]10
[/TD]
[/TR]
</tbody>[/TABLE]



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