View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default 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