# Ranking & SumProduct

#### cyortsos

##### New Member
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

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Replies
5
Views
1K
Replies
3
Views
651
Replies
9
Views
440
Replies
8
Views
370
Replies
2
Views
219

### Forum statistics

1,196,447
Messages
6,015,321
Members
441,889
Latest member
balolaptopgiaolong

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back