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

[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?

 

[Ron Rosenfeld]

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?

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



--ron

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Jerry W. Lewis]

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

array entered (Ctrl-Shift-Enter)

Jerry

 

[Ron Rosenfeld]

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

array entered (Ctrl-Shift-Enter)

Jerry

In XL2002, there is no need to array-enter this formula.


--ron

 

[Thomas]

Or in any version...

In XL2002, there is no need to array-enter this formula.

--ron

 

[Jerry W. Lewis]

Thanks, I shot from the hip and didn't have time to test it.

Jerry