IF function

IF function works like in Excel, first you need to have the condition; after coma, you have a function result if the condition is fulfilled, and after the second coma is the result if the condition is not fulfilled.

The formula that counts what % of kills was in the side-out:

=IF(VSCOUNT("*22A#")=0,"—",VSCOUNT(VSAND("*22A#","*R;B-0"))/VSCOUNT("*22A#"))

It means that if player #22 didn't have any kills, the cell would be blank, and if he had, then we divide the number of kills that happened in the first ball by the number of all kills.

The formula for # of kills in the transition per set looks like this:

=IF(VSSETCOUNT("*22")=0,"—",VSCOUNT(VSAND("*22A#","*R;B-0;NOT"))/VSSETCOUNT("*22”))

If player #22 didn't play in any set, the cell would be blank; otherwise, the number of kills played in transition by this player will be divided by the number of sets in which this player was on the court.

This formula counts what percentage of serves of a player whose number is in cell B3 was jump serve:

=IF(VSCOUNT(VSCELL("(1)S",Sheet1!$B3))=0,"",VSCOUNT(VSCELL("(1)SQ",Sheet1!$B3))/VSCOUNT(VSCELL("(1)S",Sheet1!$B3)))