How to choose and add the highest 7 numbers out of 10?

[perfection]

Suppose i have a students's marks in 10 cells and wish 2 add the best
7 (the seven best will naturally vary from student to students).
togethe to create his final mark how can this be done?

Thanks

 

[Gord Dibben]

=SUM(A1:A10)-SUM(SMALL(A1:A10,{1,2,3}))


Gord Dibben MS Excel MVP

 

[Ron Rosenfeld]

Suppose i have a students's marks in 10 cells and wish 2 add the best
7 (the seven best will naturally vary from student to students).
togethe to create his final mark how can this be done?

Thanks

=SUM(LARGE(A1:J1,{1,2,3,4,5,6,7}))

or

=SUM(A1:J1,-SMALL(A1:J1,{1,2,3}))

--ron