=COUNTIF(A1:A100,"W")/COUNTA(A1:A100)
=COUNTIF(A1:A100,"L")/COUNTA(A1:100)

Format cell as percentage

ma ma no teeth

"Bizman2125" wrote:

I have 1 column. It contains a W or an L in each individual cell down the
column to confirm wins and losses. How do I create a formula in a cell at
the bottom of that column to calculate the percentage of W to the entire
column of W and L?

Thank you,

Stephen