Serve formulas

All serve attempts by a particular player:

• =VSCOUNT("*4S")

Or (when the serving player's number is in the cell A2):

• =VSCOUNT(VSCELL("(1)S",B3))

All ace serves by particular player:

• =VSPER("*4S#")

Or (when the serving player's number is in the cell A2):

• =VSPER(VSCELL("(1)S#",B3))

This formula counts the percentage of won points after serve:

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

This formula counts all serves that were served from zone one to zone one or nine

• =VSCOUNT(VSAND(VSOR(VSCELL("(1)S11",Sheet1!$B$3), VSCELL("(1)S19",Sheet1!$B$3))))