Welcome to the Board.

First - you can shorten the formula being used in columns F3:G9

F3: =SUMIF('DIV 1 Scores'!$B$4:$B$174,$B3,'DIV 1 Scores'!$F$4:$F$174)
copy down to F9

G3: =SUMIF('DIV 1 Scores'!$B$4:$B$174,$B3,'DIV 1 Scores'!$E$4:$E$174)
copy down to G9

I would then (given relatively small no. of calcs) dispense with RANK and revert to a SUMPRODUCT based approach in Column A such that

A3: =1+SUMPRODUCT(--(($G$3:$G$9+($F$3:$F$9/1000))>($G3+($F3/1000))))
copy down to A9