Adding column numbers

[Phil]

Given a column of 20 numbers how do you sum the top 5 without having to sort
the column.

Thanks

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom