Pulling the largest numbers
 

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

Pulling the largest numbers
 

=SUM(LARGE(A1:A10,{1;2;3;4}))

HTH
--
AP

"Melanie" a écrit dans le message de
news: ...
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

Pulling the largest numbers
 

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

Vaya con Dios,
Chuck, CABGx3



"Melanie" wrote:

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