Ranking based on two columns

Hey all, trying to create a ranking column based on two separate columns.

This is used for an archery league. There's the A score and B score. I need to rank each person first by the A score and then the B score. I can't just do it by sorting because each person will get a point total based on their ranking. If the person is 1st they get 4 points, 2nd through 5th they get 3 points, 6th through 10th they get 2 points, and 11th through 20th they get 1 point.

Any help would be greatly appreciated. I've attached an example to this post.

NBVC, you're the best! Thanks for the help, looks to be working like a charm.

Ok so I need to do this for a C column too now. Rank on first column A, then column B, and then lastly column C. Any help?

NBVC, you sir are the best!

I want to rank based on the following table. Can anyone help.Untitled.png

Hi NBVC.

I'm working on a problem for someone which is pretty similar to this but haven't been able to find reference to the use of -- in a formula. Would you mind telling me what that syntax actually means in Excel?

Many thanks

Dave