First thank you for the rapid reply, Sixth Sense I tried again to input this formula that indeed worked in your example it is the same one i had tried previosly and tried agian to no success, I would love to show an example but as yet do not have the knowledge.I used this formula on this same spreadsheet to rank three other scoring columns;rd1,rd2,rd3, all with success. but again when I try rank columns;rd1+rd2,or total It doesn't compute, I am using the formula correctly per your example=RANK(H2,$H$2:$H$25) this is an example of my input for column "I" I want this column to rank "H" this is rd1+rd2. There is also column "L" the three round total,my goal is to have column "M" sort the list by players totals first, second ,third etc.By the way i don't know this formula and at this point cannot even get them to rank.I am using excel from office 2000,on windows xp,via msn 8.Thanks agian fire fytr and sixth sense,if you have any more advise i will appreciate it. Good day!