I am attaching a copy of the file I use to track stats for my dart team.
If you look at the worksheet 'wk17', I'm trying to figure out an easy way to calculate each individuals stats in the area at the bottom of the sheet (D37 - O45).
Background: We play 1001 double in, double out. 16 games each night played on two boards: three on three. I would like to just input the data (who started, who finished, and what scores the players threw in a game, and have Excel calculate, for the night, how many starts, finishes, scores >=95 a player had as well as their number of throws, what their total score was from those throws (white cells) and what their average was for the night.
Can anyone help me?
"Know enough about Excel to be dangerous"
Bookmarks