That worked awesome! thanks so much.. One follow up question, occasionally
there is a tie- how can I enhance this formula to take out those ties so its
not counted against their teams win % ? thanks

"Peo Sjoblom" wrote:

First of all 2 wins out of 3 is not 75%, it would be 67% if you round it to
the nearest
percentage or 66.67% if using percentage with 2 decimals. Anyway assume the
data starts in B2,
format C2 as percentage and put this formula there

=IF(B2="","",COUNTIF($B$2:B2,"Win")/COUNTA($B$2:B2))

copy down as many games you expect and it will return a blank when B is
empty



--


Regards,


Peo Sjoblom



"tsondrini" wrote in message
...
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.....