Thread: Top 10 numbers
View Single Post
  #2   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

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