Try this:

=COUNTIF($B$1:B1,"Win")/COUNTA($B$1:B1)

Copy down as needed. Format Column C as percentage.

HTH,
Elkar


"tsondrini" wrote:

I am new to excel and I want to create a formula to keep a running win
percentage% for my sons basketball team. I would like to enter the game in
column A and then the result in column B (win or loss) and have colum C keep
a running winning %. Can someone sugest a formula? thanks

for example I want it to look like this:
A B C
tech vs state Win 100%
Tech Vs Umass Loss 50%
Tech vs uconn Win 75% etc.....