Need help with excell.

[Saphyron]

Made this document.

Is there a possible way for excell to automaticaly place people up and down in the document depending on what their total dps is?

Basicly

player 1 has 10k on each of 8 boss fights in total he has 80k dps
player 2 has 10k on 7 fights but 11k on the 8th fight so he has a total of 81k
player 3 has 9k on all fights so in total he has 72k

Then I want it to place player 2 automaticaly on spot number 1. Player 1 on spot 2 and player 3 on spot 3

And then if by chance player 3 go uber mode and suddenly has 11k dps on each fight when i plug it in it automaticaly puts him at spot 1 and the rest 1 spot lower.

Sorry if badly explained.