Perfect pass% for a specific player:
- =VSPER("*4R#”)
Or (where the passing player number is in the cell A2):
- =VSPER(VSCELL("(1)R#”,A2))
Good pass% for a specific player:
- =VSPER(VSOR("*4R#”,”*4R+”))
Or (where the passing player number is in the cell A2):
- =VSPER(VSOR(VSCELL("(1)R#”,A2),VSCELL("(1)R+”,A2)))
Passing average on a 4-point scale for a specific player:
- =IF(VSCOUNT("*4R")=0,"--",(VSCOUNT("*4R#")*4+VSCOUNT("*4R+")*3+VSCOUNT("*4R!")*2+VSCOUNT("*4R-")*1+VSCOUNT("*4R/")*0,5)/VSCOUNT("4R”))
Or (where the passing player number is in the cell A2):
- =IF(VSCOUNT(VSCELL("(1)R",$A2))=0;"--";(VSCOUNT(VSCELL("(1)R#",$A2))*4+VSCOUNT(VSCELL("(1)R0+",$A2))*3+VSCOUNT(VSCELL("(1)R0!",$A2))*2+VSCOUNT(VSCELL("(1)R0-",$A2))*1+VSCOUNT(VSCELL("(1)R0/",$A2))*0.5)/VSCOUNT(VSCELL("(1)R",$A2)))
Reception in zone 1:
- =VSCOUNT("*4R10")
Or (where the passing player number is in the cell A2):
- =VSCOUNT(VSCELL("(1)R10",A2))
Good reception in zone 5:
- =VSPER(VSOR("*4R50#","*4R50+"))
Or:
- = VSPER(VSOR(VSCELL("(1)R50#",Sheet1!$B$4),VSCELL("(1)R50+",Sheet1!$B$4)))
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article