Hey all. I can't think of anything that would let me do this, but lets say I
have a column (we will say column A) that contains numbers from row 1 to row
100. I would like to put a formula at the bottom of this tha will calculate
the top 3 numbers in this column and sum them together.

Hi
=SUM(LARGE(A1:A100,{1,2,3}))

--
Regards
Frank Kabel
Frankfurt, Germany
"havocdragon" schrieb im Newsbeitrag
...
Hey all. I can't think of anything that would let me do this, but lets say
I
have a column (we will say column A) that contains numbers from row 1 to
row
100. I would like to put a formula at the bottom of this tha will
calculate
the top 3 numbers in this column and sum them together.

=SUM(LARGE(A1:A100,{1,2,3}))

HTH
Jason
Atlanta, GA

-----Original Message-----
Hey all. I can't think of anything that would let me do
this, but lets say I
have a column (we will say column A) that contains
numbers from row 1 to row
100. I would like to put a formula at the bottom of
this tha will calculate
the top 3 numbers in this column and sum them together.
.

One way

=SUM(LARGE(A1:A100,{1,2,3}))


Regards,

Peo Sjoblom

"havocdragon" wrote:

Hey all. I can't think of anything that would let me do this, but lets say I
have a column (we will say column A) that contains numbers from row 1 to row
100. I would like to put a formula at the bottom of this tha will calculate
the top 3 numbers in this column and sum them together.

How about
=LARGE(A1:A100,1)+LARGE(A1:A100,2)+LARGE(A1:A100,3 )

Or more generally, suppose cell B1 countains a number that represents the
number of items to be summed (in this example 3), then

=SUM(LARGE(A1:A100,ROW(INDIRECT("1:"&B1))))
entered as an array formula (hold down control+shift then enter when
entering the formula)

--
Return email address is not as DEEP as it appears

"havocdragon" wrote in message
...
Hey all. I can't think of anything that would let me do this, but lets say
I
have a column (we will say column A) that contains numbers from row 1 to
row
100. I would like to put a formula at the bottom of this tha will
calculate
the top 3 numbers in this column and sum them together.

If you have the following numbers...

10
8
12
10
6

....which result do you expect, 32 or 30?

In article ,
"havocdragon" wrote:

Hey all. I can't think of anything that would let me do this, but lets say I
have a column (we will say column A) that contains numbers from row 1 to row
100. I would like to put a formula at the bottom of this tha will calculate
the top 3 numbers in this column and sum them together.