Excel 2007 : top ten and adjacent cell sum

[lizsantiago07]

Hi, can someone help me to solve this.. i am making a roll book (for grades) the thing is that i have all the grades of each student in different columns example
student 1 a1 b1 c1 d1 e1 f1
25 35 40 50 45 50
there are 12 grades for each student and i need to find the top 8 grades and highlight those cells and also sum them, the problem is that each grade is worth different kind of points, for example a1 is 45, b1 is 50, c1 is 40 and so on
is there an easy way to do this? i was thinking that i might have to add a column to convert those points into percentage so that i can find the 8 best percentage and then sum the adjacent cell.
i dont sum or work with the percentage because the grade software that my school uses needs the points and not percentages.
i tried theconditiona formatting but i dont know how to sum the columns next to the highlithed ones. any ideas???

[jeffreybrown]

How about this...

I put a rank in row 3 and then used it to do the hightlighting

[lizsantiago07]

thks jeff but that wont work because it ranks based on the points and not the actual value in percentage. for example the grades are 25/45 35/50 40/40 if i use rank 50 will be rank 1 but in actual grades 40/40 is 100% thus an A grade and 35/50 is a C and 25/45 is an F.

[martindwilson]

i think yo have to make them the same anyway how can you compare them otherwise?

[jeffreybrown]

Can you build a mock workbook with your exact requirements? What you have and what you expect.

[lizsantiago07]

THIS IS AN example so that you understand

[jeffreybrown]

This is my take...

[lizsantiago07]

thanks again jeff, that works!!

[jeffreybrown]

You are very welcome

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save