I have recently made a spreadsheet on Google docs to keep track of my bets in a game, All of my formulas work except from one. When I try to calculate the percentage of games that I have won it takes into account matches that I have written SKIP or DRAW or CLOSED on, right now I am using this formula
=SUMPRODUCT(COUNTIF(G2:G1000,{"Win";"Draw";"Closed";"Skip"}))/COUNTA(G2:G1000)
I thought that this worked to begin with but then I found out that if I add in a DRAW or a CLOSED or a SKIP then the win percentage goes up, and if i remove one, it goes down again.
Is there a way for me to exclude the words DRAW, SKIP and CLOSED from the formula so that the win percentage is only effected if I write WIN or LOSE?
here is a link to my current spreadsheet,
https://docs.google.com/spreadsheets/d/1HqbAMYDJz7w8Z0PHSgkJxVSsNmZ1heI3-echdSthQpQ/edit?usp=sharing
=SUMPRODUCT(COUNTIF(G2:G1000,{"Win";"Draw";"Closed";"Skip"}))/COUNTA(G2:G1000)
I thought that this worked to begin with but then I found out that if I add in a DRAW or a CLOSED or a SKIP then the win percentage goes up, and if i remove one, it goes down again.
Is there a way for me to exclude the words DRAW, SKIP and CLOSED from the formula so that the win percentage is only effected if I write WIN or LOSE?
here is a link to my current spreadsheet,
https://docs.google.com/spreadsheets/d/1HqbAMYDJz7w8Z0PHSgkJxVSsNmZ1heI3-echdSthQpQ/edit?usp=sharing