sum the top 5 in a range

[oliver_penney]

hi

if i have list of scores, that may contain blanks, how do i sum the highest 5?

and bear in mind there may be 2 joint 5th entries, e.g.

98,97,96,95,94,94,90,80,70,65

thanx in advance

 

[Oaktree]

=SUM(LARGE(A1:A10,{1,2,3,4,5}))

 

[oliver_penney]

aaaaah, very nice

thanx a bundle

sticking in an array at the start

and i'm a Bertrand Russell fan too reading "Power" atm