I need a formula to keep a running percentage....HELP!!

[tsondrini]

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.....

 

[Elkar]

Try this:

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

Copy down as needed. Format Column C as percentage.

HTH,
Elkar

 

[Peo Sjoblom]

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]

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]

If you only want to count wins or losses and disregard anything else change
the formula to

=IF(B2="","",COUNTIF($B$2:B2,"Win")/SUM(COUNTIF($B$2:B2,{"Win";"Loss"})))

do the same and copy down the formula as long as you want


--


Regards,


Peo Sjoblom