Adding the highest numbers in a column

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Hello:

I have several columns of 8 numbers in a worksheet and I
want the sum of the largest 6 numbers in each column. What
formula do I use to make this calculation?

Thanks
 
-----Original Message-----
Hello:

I have several columns of 8 numbers in a worksheet and I
want the sum of the largest 6 numbers in each column. What
formula do I use to make this calculation?

Thanks
.
I have figured out what I need to do.
Click to expand...
 
What if there is a tie? Assume there are these numbers

2
2
2
3
4
5
6
7


if you want all numbers included

=SUMIF(A1:A8,">="&LARGE(A1:A8,6))

if just the 6 numbers even if there is a tie

=SUMPRODUCT(LARGE(A1:A8,{1,2,3,4,5,6}))


-

Regards,

Peo Sjoblom
 
Back
Top