I’m keeping teams win/lost percentage. Need help in figuring the % based on win/lost scores.
How do I get the correct percentage based on games played. This is really based on baseball scores.
Correct spreadsheet in my other comment below.
Tell in words what is the order of calculations.
Perhaps,
=1/COUNTIF($B$2:$B$5;$B2)
Here’s the actual spreadsheet. I’m looking for the winning % of the Padres. So far, they lost both opening games. So the winning percentage would be zero.
Team Percentage.ods (34.8 KB)
I got it, =COUNTIF(E2:E163,“Padres”)/162
In simple terms the percentage is games won / games played. Your sample seems to have no way of determining games played, and would rely on a COUNTIF of column E to determine games won. This could be unreliable if there is, for example, a spelling error in E or superfluous spaces.
By my reckoning using your formula, the Rockies would be on a winning percentage of 1.25% or thereabouts, shouldn’t they be on 100%? You might want to untick your Solution mark to let others know it hasn’t been solved.
The below spreadsheet has same issues with potential misspellings. Enter the scores in the yellow cells, I have made up some scores. I figure a tie is not a win so detracts from the winning percentage but I don’t know about these things.
Team PercentageEA.ods (69.6 KB)
Hi Al,
I have it setup to countif only for the Padres for that is the only team I am interested in seeing the win percentage [=(COUNTIF(F3:F164,“Padres”)/162)] and it is based on the full regular 162 game season (and not the post season playoff games).
I could add another column for the other teams win percentage against the Padres. In this case the Rockies would be currently be at 66% and the Padres at 33%, but that’s another day.
Thank you for your suggestion.
Look at it another way, if padres had won both games they would have a winning percentage of a bit less than 1.25%
~1.25% is based on the whole season of 162 games. 2 out of 162 is 1.23%. So, it will always be “low” at the start of the season.
If they had won both games they would have played two and won two. That is 100% winning percentage.
It would probably change during year but you should see the current rate otherwise why not just do a simple calculation at the end of the year as that would be the only time you have an accurate figure?
At least count the games played =COUNTIF($E$2:$E$163,"Padres")/COUNTA($E$2:$E$163)
Sorry, wrong data provided. See revised spreadsheet uploaded. I need the percentage in the Winning column (based on team total winnings).
Thanks for the suggestion.