Adding column numbers
 

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

Thanks

Adding column numbers
 

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

--


Regards,


Peo Sjoblom

"Phil" wrote in message
...
Given a column of 20 numbers how do you sum the top 5 without having to
sort
the column.

Thanks