Pease help with a formula to select 7 best marks out of 12

[perfection]

I am a teacher and we have a system of evaluating students 12 times a
year and finally choosing 7 of the best marks obtained by them for
further processing. Can i make a formula that will select, add and
display the 5 best marks of the 12 ?

I don't mind a sample excel sheet attached and sent to my e-mail i
which is <[email protected]

 

[starguy]

would you send sample data.

 

[Ken Johnson]

Hi perfection,
I spotted this little gem yesterday in a reply to a question asking
about the sum of the 16 highest scores in a row of 20 columns

=SUM(LARGE($F6:$Z6,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16}))

I'm sure you could adapt it to your situation to display the sum of
the best 7 scores out of 12
eg =sum(large($B2:$K2,{1,2,3,4,5,6,7}) for the sum of the 7 best scores
in columns B to K (12 columns) for the student with scores in row 2.

Similarly, large($B2:$K2,1), large($B2:$K2,2), large($B2:$K2,3) etc
returns the individual top scores.

Ken Johnson