Forum Discussion
Excel 2016 Formula - skins
Thank you so much for your help Sergei. I have one additional problem. For Column I, Player 3 is participating in Skins (c8 is a y) and the score is 3. Player 4 is not participating and also has a 3 in Column I row 9. Player 3 should be the winner and be highlighted. When 2 players have the lowest score and one player has a y in column c and the other player does not, the player with the y in column c is the winner. How do I add that to the formula that you gave me?
Thanks again for all of your help.
Okay, so we shall count with the condition
=AND($C6="y",F6=MINIFS(F$6:F$15,$C$6:$C$15,"y"),COUNTIFS($C$6:$C$15,"y",F$6:F$15,F6)=1)
Updated file is attached
Thank you so much Sergei for the excellent answer. The formula is perfect and I appreciate all your hard work.
The skins are now calculating correctly. My last task is to count the total skins and place them in column P row 4. For example, there are 3 skins highlighted as wins. Can you help me with the formula to put the 3 wins in column P row 4.
Thanks so much for your help.
I'd do that with helper row - add formula as
=SUMPRODUCT(($C6:$C15="y")*(F6:F15=MINIFS(F$6:F$15,$C$6:$C$15,"y"))*(COUNTIFS($C$6:$C$15,"y",F$6:F$15,F6:F15)=1))
in that row, column by column, and sum to P3.
In attached above formula is in F5:N5