Thread: Adding column numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default 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


Reply With QuoteReply With Quote