Pulling the largest numbers

M

Melanie

I have a series of data with the information in rows. For each row - I want
to find the 4 largest numbers, and add them together in the last cell of the
row. I am looking for the best functions to use.

Any help would be greatly appreciated
 
C

CLR

=SUM(LARGE(A1:T1,{1,2,3,4}))
Adjust the range to suit.......

Vaya con Dios,
Chuck, CABGx3
 
Top