Ranking & SumProduct

[cyortsos]

Hello all,

I am building a National Hockey League standings table that is based on "percentage of points available" to each term (points/(games played*2)). Unfortunately, some teams are tied in this category, so i have implemented several tie-breakers that I was hoping would help me rank each team more accurately. I am using the RANK and SUMPRODUCT formulas to put together division rankings (1-5), but for some reason, the formula is not placing the teams in their corresponding 1-5 spots.

Formula for Ranking the teams: =RANK(G4, $G$3:$G$7, 0)+SUMPRODUCT(--(G4=$G$3:$G$7),--(C4<$C$3:$C$7),--(E4>$E$3:$E$7),--(F4>$F$3:$F$7))

C	D	E	F	G	H	I
Games Played	Points	Goal Differential	Goals For	Percentage of Points Avail.	Rank	Team
36	51	25	114	0.708	2	Montreal
35	50	23	100	0.714	1	Boston
36	44	12	91	0.611	3	Ottawa
36	44	12	112	0.611	3	Toronto
37	34	-16	98	0.459	5	Buffalo

<tbody>
</tbody>

In this scenario, Toronto should be ranked higher than Ottawa - based on the tie-breaker Goals For - but for some reason, they are listed as tied.

Any and all help is greatly appreciated. Thank you in advance.

-CY