I'm trying to get handicap numbers for a billiard tournament and have a table tblHistory that includes Lname, total games(per event), total wins(per event) and need handicap (wins/totals) for the last 100 total games. I'm using:
=SUMPRODUCT(--(tblHistory[Total Wins]>0),--(tblHistory[Lname]="lane"),tblHistory[Total Wins]) / (SUMPRODUCT(--(tblHistory[Total Games]>0),--(tblHistory[Lname]="lane"),tblHistory[Total Games]))
This will give me all games divided by all totals. It's a beginning but not compete.
As a side note: I would also like to get handicap by Lname and Date and Lname and Team numbers.
Handicap.png
Bookmarks