World Cup Group Ranking (Yes I know, another World cup Thread)

[ian.clark]

Hi Guys,

So, what I wanted to do was have a ranking next to each group so I can pre-populate all my data as the games are played..


Below is what my table is returning (R=Rank, G=Group, rest are self explanitory)
This is based off the first 2 games having the following result (to test)
Brazil 1 vs Croatia 0
Mexico 1 vs Cameroon 2

A B C D E F G
R G Team GF GA GD PTS
2 A Brazil 1 0 1 3
6 A Mexico 1 2 -1 0
1 A Cameron 2 1 1 3
8 A Croatia 0 1 -1 0


=RANK(G2,$G$2:$G$5)+(SUMPRODUCT(--($F$2:$F$5>F2)))+(SUMPRODUCT(--($D$2:$D$5>D2)))
however instead of giving me ranks of 1,2,3,4 its goign 1,2,6,8

Attached is a copy of the spreadsheet (with all my works tipping and stuff removed)