Set number

For the set number, you have put the S filter and add the number of the analyzed set that is interesting to you.

The formula counts all kill attacks in the first set looks like this:

• =VSCOUNT("*A#;S1")

This formula counts all serve errors in the last set  looks like this:

• =VSCOUNT("*S=;SL")

The formula counts the positive reception of a player whose number is in cell B2, and the analyzed set number is in cell B3 looks like this:

• =VSPER(VSOR(VSCELL("*(1)R#;S(2)",B2,B3),VSCELL("*(1)R#;S(2)",B2,B3)))

The formula counts the percentage of won points in the side out where the analyzed set number is in cell B3 looks like this:

• =VSCOUNT(VSCELL("aS;S(1);WR-0",$B3)))/(VSCOUNT(VSCELL("aS;S(1)",$B3))