Formula to rank in two ways

For a tiebreaker question on a quiz, I need a formula that does the following:
- First, create a ranking based on the column total score
- In case of a tie in previous, the team closest to the answer to the tiebreaker question should come first

So I thought to work with a rank formula first and supplement it with a rank formula where (correct answer - their answer to the tiebreaker question) should be as close to zero as possible.
But I still didn't find the correct formula. Can anyone help me?

Now the ranking is the other way.

What is wrong with bebo021999's formula here:
https://www.excelforum.com/excel-gen...ml#post5804188

This gives the reverse answer... Now the Tiebreaker question decides who will win