View Single Post
  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

=SUM(LARGE(A1:A16,ROW(INDIRECT(("1:10")))))

which is an array formula., so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michele P" <Michele wrote in message
...
I have a row of (16) numbers. I want to sum the top (10) greatest numbers.

I
know how to get the greatest number by using MAXA, but how do I tell it to
get the top ten greatest numbers and add them together? HELP?