Top 10 numbers

[Guest]

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

 

[Ron Rosenfeld]

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

=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

 

[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

 

[Guest]

your first formula works fine, thanks vert much