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

P

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
 
R

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
Click to expand...

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

or

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

--ron
 
Top