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?