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

[Michele P]

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?

 

[Peo Sjoblom]

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

 

[Jason Morin]

Assuming row 1:

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

or A11

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

HTH
Jason
Atlanta, GA

 

[galimi]

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,rangeofnumbersinrow)<11,rangeofnumbersinrow,0))

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

http://www.ingenio.com/categories/categorylist_expand.asp?sid=5228306

 

[Bob Phillips]

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