Ranking in Excel

Hi, I'm trying to rank score on a score sheet but the final scores to determine placing are not in consecutive cells and the ranking formula doesn't seem to want to work. Can anyone help me out here?

Thanks

AttachmentSize
Scoring.xlsx11.92 KB

try this

in the all final score cells(K7,K12,K17...) insert the following formula:
=IFERROR(SUM(J7:J8),"")

in the all Rank cells(A7,A12,A17...) insert the following formula:
=IFERROR(RANK(K27,$K$7:$K$37,0),"")

Thanks Wabre, i tried as you

Thanks Wabre, i tried as you said and the rank field comes up blank.

Sorry Wabre, just looked at

Sorry Wabre, just looked at it again and noticed that the string for the Rank started with K27 instead of K7. Looks to be working now!
Saying that, is there a way to get the ranking to position in order from 1 to 8 or whatever number?

Thanks a million

??

You want to see all ranks 1-8

or

you want the total score ranked #1 on top followed by #2,#3

Total Score

I want the Total Score ranked so i want all the scores, name and total to be in order so it looks the same as it does now but in order from 1-8.

Thanks

if you are looking to have

if you are looking to have the data for the #1 rank to move up once it has been ranked automaticlly that not something i can help you with.

manually once it is ranked u can move them and place in the order u want to see them.

another solution is to have a seperate table the pulls from this one

name rank score
J. doe 1 43
w. doe 2 40

OK Thanks for all your help!

OK Thanks for all your help!