In Excel, how to sum top 10 greatest values in a row of numbers?
 

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?

One way although note that if there are multiple numbers that are of the same
value it won't include let's say the 11th number although it's the same as
the 10th


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

Regards,

Peo Sjoblom

"Michele P" wrote:

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?

Assuming row 1:

=SUMPRODUCT(LARGE(1:1,ROW(INDIRECT("1:10"))))

or A1:P1

=SUMPRODUCT(LARGE(A1:P1,ROW(INDIRECT("1:10"))))

HTH
Jason
Atlanta, GA

-----Original 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?
.

Michele,

You will have to enter the following formula an an array (i.e., press
control, shift and then the enter key simultaneously)

=sum(if(rank(rangeofnumbersinrow,rangeofnumbersinr ow)<11,rangeofnumbersinrow,0))

Replace the above placeholder, rangeofnumbersinrow with the actual range of
numbers in the row specified.

http://www.ingenio.com/categories/ca...sp?sid=5228306

"Michele P" wrote:

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?

=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?