Thread
:
In Excel, how to sum top 10 greatest values in a row of numbers?
View Single Post
#
5
Bob Phillips
Posts: n/a
=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?
Reply With Quote