Hello, I thought I had my workbook figured out but it seems I am way off. There are quite a few things I am trying to accomplish with this but it all revolves around selections made from a dropdown menu.
The orange dropdown menus contains 7 selections seen in column N.
First: If one of the first 6 are selected, Fall 6, Tech Fall 5, Major Decision 4, Decision 3, Injury Default 6, and Disqualification 6, I want a single count added to the green cell (A2), if the last option is selected, Loss 0, then I want a single count added to the pink cell (B2). This is to keep track of wins and losses.
Next: I'd like the win percentage calculated in the blue cell (D2)
Finally: I'd like total points to be calculated based on how the participant won. These are the numbers that are with the text in column N. So for example if a participant wins by Fall 6 then 6 points will be added to the yellow cell (E2)
There are more things I will eventually need to accomplish but this will get me where I need to be if anyone can help!? Thanks in advance for your time.
The orange dropdown menus contains 7 selections seen in column N.
First: If one of the first 6 are selected, Fall 6, Tech Fall 5, Major Decision 4, Decision 3, Injury Default 6, and Disqualification 6, I want a single count added to the green cell (A2), if the last option is selected, Loss 0, then I want a single count added to the pink cell (B2). This is to keep track of wins and losses.
Next: I'd like the win percentage calculated in the blue cell (D2)
Finally: I'd like total points to be calculated based on how the participant won. These are the numbers that are with the text in column N. So for example if a participant wins by Fall 6 then 6 points will be added to the yellow cell (E2)
There are more things I will eventually need to accomplish but this will get me where I need to be if anyone can help!? Thanks in advance for your time.