Forum Discussion
Excel 2016 Formula - skins
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
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.
We may add to helper row (#5) calculation of player on which position won
=IFNA(MATCH(1,INDEX(($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),0),0),0)
after that calculate total wins for each player as
=SUMPRODUCT(--($F$5:$N$5=(ROW()-ROW($E$5))))
