Volleyball points

%3CLINGO-SUB%20id%3D%22lingo-sub-2457615%22%20slang%3D%22en-US%22%3EVolleyball%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2457615%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20court%20(beach%20volleyball)%20and%205%20players.%20The%20teams%20are%20changing%20after%20each%20match%20(20%20min.)%3C%2FP%3E%3CP%3EThe%20player%20can%20be%20on%20any%20side%20of%20the%20court%2C%20and%20the%20team%20is%20made%20out%20of%202%20players.%3C%2FP%3E%3CP%3EAfter%2020%20min%2C%20the%20team%20who%20have%20the%20most%20points%20wins%2C%20then%20each%20player%20is%20getting%201%20point.%3C%2FP%3E%3CP%3Ethe%20player%20can%20be%20on%20any%20side%20of%20the%20net.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20have%20all%20the%20points%20calculated%20by%20a%20formula%20at%20the%20end%20of%20any%20match.%3C%2FP%3E%3CP%3EI%20have%20a%20sample%20of%205%20matches%20with%20one%20player%20resting%20for%20every%20match.%3C%2FP%3E%3CP%3EOnly%20the%20players%20for%20team%20who%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2457615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2465442%22%20slang%3D%22en-US%22%3ERe%3A%20Volleyball%20points%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2465442%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1081289%22%20target%3D%22_blank%22%3E%40Razvan465%3C%2FA%3E%20%2C%3CBR%20%2F%3E%3CBR%20%2F%3Eare%20you%20searching%20for%20a%20simple%20%3DSUM%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20simply%20write%20an%20table%20with%20each%20player%20and%20their%20total%20points%20and%20their%20positioning%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20need%20further%20help%2C%20try%20to%20provide%20more%20information%20how%20you%20wan't%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3CBR%20%2F%3ESchnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3E%22First%2C%20No%20system%20is%20safe.%20Second%2C%20Aim%20for%20the%20impossible.%20Third%2C%20no%20Backup%2C%20no%20Mercy%22%20-%20Schnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20answer%20helped%20you%3F%20Don't%20forget%20to%20leave%20a%20like.%20Also%20mark%20the%20answer%20as%20solved%20when%20your%20problem%20is%20solved.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I have a court (beach volleyball) and 5 players. The teams are changing after each match (20 min.)

The player can be on any side of the court, and the team is made out of 2 players.

After 20 min, the team who have the most points wins, then each player is getting 1 point.

the player can be on any side of the net.

I would like to have all the points calculated by a formula at the end of any match.

I have a sample of 5 matches with one player resting for every match.

Only the players for team who 

1 Reply
Hi @Razvan465 ,

are you searching for a simple =SUM ?

You can simply write an table with each player and their total points and their positioning

If you need further help, try to provide more information how you wan't it.

Best regards,
Schnittlauch

"First, No system is safe. Second, Aim for the impossible. Third, no Backup, no Mercy" - Schnittlauch

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved.