Top 10 numbers

R

Ron Rosenfeld

I have a range of numbers. How can I sum the top 10 numbers of that range?
Click to expand...


=SUM(LARGE(A:A,{1,2,3,4,5,6,7,8,9,10}))

or the **array-formula**

=SUM(LARGE(A1:A100,ROW(INDIRECT("1:10"))))

To enter an **array-formula**, hold down <ctrl><shift> while hitting <enter>.
Excel will place braces {...} around the formula.

Note that unlike the first formula, an array formula may NOT refer to an ENTIRE
column.


--ron
 
M

Mangesh Yadav

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
 
Top