VSSETCOUNT function

If you want to get the number of sets played, you use the VSSETCOUNT function.

Sets played by the team

• =VSSETCOUNT("*")

Sets played by a player (in cell A3 is the player number):

• =VSSETCOUNT("*12")
• =VSSETCOUNT(A3)

Time spend on the court by a player (in cell A3 is the player number):

• =VSCOUNT(VSCELL("S;*PC(1)",$A3))/VSCOUNT("S")

You can also use the VSSETCOUNT function to count the plays performed by set, for example:

• =VSCOUNT(VSCELL("(1)A",B2))/VSSETCOUNT(B2) 

When in cell B2, you have the attacking player number.