Forum Discussion

stevesteph1234's avatar
stevesteph1234
Copper Contributor
Feb 12, 2019

Excel 2016 Formula - skins

I am working on a formula that will calculate a Skins game for golf.  The criteria is that players participating in the skins game will have a y (for participating in skins) in column c.  Each column...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 13, 2019

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

stevesteph1234's avatar
stevesteph1234
Copper Contributor
Feb 14, 2019

Thank you so much Sergei for the excellent answer.  The formula is perfect and I appreciate all your hard work.

  • stevesteph1234's avatar
    stevesteph1234
    Copper Contributor
    Mar 01, 2019

    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.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 01, 2019

      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

      • stevesteph1234's avatar
        stevesteph1234
        Copper Contributor
        Mar 04, 2019

        My requirements for the skins game has changed once again.  I need to total the number of skins game won by each player.  I am attaching the Example spreadsheet.  Can you help me with the formula that would take each player and total their wins.  Player 1 has won no skins game so his #Won by Player Column ), Row 6 is 0.  Player 3 has won 3 games (as highlighted) his total in Column O Row 8 is 3.

Resources