Rank formula needed

[tjdate]

Evening again guys,

Unfortunetely, this is my second question in two days as my latest project has me visiting some formulas that I'm not particularly familiar with.

I need to rank a team based upon its score in one column and if this is the same score as another team, then the deciding factor is then what each team scored in another column. I am aware that there are a few ways to do this, however, I also need the same formula to ignore blank cells so that a team that did not enter does not receive any points.

Hopefully the attached spreadsheet shows what I mean.

Thanks again for the help.

TJ