How to add the 4(say) largest numbers in a column

  • Thread starter Thread starter Slimer
  • Start date Start date
S

Slimer

I am working on a problem where i need to add up the 4
largest numbers from a column of 10 numbers, this has to
be repeated for over 200 columns so i don't want to have
to sort each column into order individually and then sum
the top 4.

Is there a quick way of performing this simple operation?
 
I am working on a problem where i need to add up the 4
largest numbers from a column of 10 numbers, this has to
be repeated for over 200 columns so i don't want to have
to sort each column into order individually and then sum
the top 4.

Is there a quick way of performing this simple operation?
Click to expand...

=SUM(LARGE(A:A,{1,2,3,4}))



--ron
 
=LARGE(yourrange,1)+LARGE(yourrange,2)+LARGE(yourrange,3)+LARGE(yourrange,4)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top