ExcelBanter - How to sum top 5 numbers from the column of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to sum top 5 numbers from the column of numbers (https://www.excelbanter.com/excel-discussion-misc-queries/27321-how-sum-top-5-numbers-column-numbers.html)

Martin

How to sum top 5 numbers from the column of numbers

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.

Duke Carey

=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.

All times are GMT +1. The time now is 03:43 AM.