Hello:

One way:
Use the following to compute the perentage of wins, (1-wins would be
percent of losses assuming no ties.)

=COUNTIF(A2:A7,"w")/COUNTA(A2:A7)

Assumes the w/l are in a2:a7 adjust accordingly.

Pieter Vandenberg


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