Top 10 numbers
 

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

--
Rich

On Mon, 20 Jun 2005 04:21:02 -0700, "Rich"
wrote:

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

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

your first formula works fine, thanks vert much
--
Rich


"Ron Rosenfeld" wrote:

On Mon, 20 Jun 2005 04:21:02 -0700, "Rich"
wrote:

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