I need to work out a formula for a number of % wins a player makes we have a spred sheet with matches played w

Question

Team plays a number of games spread sheet as number players and games played ,number of games won number games lostlost I would like a formula to work out % won at any point during season any ideas

Present formular C to T wins & losses V=sum(W8:x8) W=COUNTIF(C8:T8,"W" ) X =COUNTIF(C8:T8 "L") I WOULD LIKE TO INCLUDE THE PERCENTAGE WINS IN COLUM Y ANY IDEAS

Answer 1

Wins / (Wins+Losses), assuming there are no ties.

so column Y = (column W) / (column W + column X)