Just to make sure. If a team won 3, tied 1, and lost 1. Their percentage
would be 70% (7 points of a possible 10)? Put the numbers (2,1, or 0) in
column A and use this formula
=SUM(A1:A10)/20
where 20 is 2 times the number of games.
or
=SUM(A1:A10)/COUNT(A1:A10)/2

The second will work better if you have blank cells, to represent unplayed
games. Just remember to input lost games as 0. If you leave the lost games
blank, you will get the wrong percentage.

"rolly g" wrote:

> Looking to set up standings for my son's hockey league and need an expert to
> help me set up winning percentage. Points are based on 2 for a win, 1 for a
> tie, and 0 for a loss. Thanks!