Thread: How to sum top 5 numbers from the column of numbers
View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default
=sum(large(column,{1,2,3,4,5})


"Martin" wrote:

I have about 100 columns with numbers. In every column there is 25 numbers. I
want to sum top 5 numbers in every column. How to do it without sorting every
column.

Reply With QuoteReply With Quote