Forum Discussion
Tennis doubles win percentage table help
My club is in a tennis league and we regularly play matches with different partners. I would like to create a table that automatically combines the data so we can learn which two-player teams have th...
=(COUNTIFS($A$2:$A$10,B14,$B$2:$B$10,A14,$F$2:$F$10,"Loss")+COUNTIFS($A$2:$A$10,A14,$B$2:$B$10,B14,$F$2:$F$10,"Win"))/(COUNTIFS($A$2:$A$10,A14,$B$2:$B$10,B14)+COUNTIFS($A$2:$A$10,B14,$B$2:$B$10,A14))You can try this formula.
- This should work also but I think you need to swap your "Loss" to "Win"
