PDA

View Full Version : how to add % W/L in v1.10



snappy
6th March 2013, 10:21 AM
I love this worksheet...

wanted to know how to add "% W/L" in the Performance Summary for EACH sport. Specifically, I would like to add a column to the "Performance by Bet Type" so i could filter each sport and see W/L for different sports and bet types. Any help would be great!

admin
6th March 2013, 12:23 PM
Hi snappy,

To do the above without adding new hidden columns to the Bets sheet would require the use of the COUNTIFS function, which isn't supported by Excel 2003 and earlier (nor by OpenOffice).

If you are using Excel 2007 or later then the process should be relatively simple.

I would add four new columns to the right of J:
K: "Wins"
L: "Losses"
M: "% Wins"
N: "%Losses"

Row 6 would have the following formulas:

K:
=IF(G6<>"",COUNTIFS(SPORT,G6,WIN,"Y"),"")
L:
=IF(G6<>"",COUNTIFS(SPORT,G6,WIN,"N"),"")
M:
=IF(K6+L6>0,K6/(K6+L6),"")
N:
=IF(K6+L6>0,L6/(K6+L6),"")

Hope that helps.