Lets say your numbers start from A1 onwards. Enter the following formula in
another column and pull down for 10 rows, and then find the sum of this new
column.
=LARGE($A$1:$A$100,ROW(A1)-ROW($A$1)+1)
Mangesh
"Rich" wrote in message
...
I have a range of numbers. How can I sum the top 10 numbers of that range?
--
Rich
|