Remember Me?

#1
 havocdragon Posts: n/a
I need a formula that will sum the top 3 number in a column

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.
#2
 Frank Kabel Posts: n/a

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.

#3
 Jason Morin Posts: n/a

=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.
.

#4
 Domenic Posts: n/a

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.

#5
 Peo Sjoblom Posts: n/a

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.

#6
 Jack Sheet Posts: n/a

=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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post jenniss Excel Discussion (Misc queries) 5 January 6th 05 09:18 PM Mike Peter Excel Worksheet Functions 6 December 8th 04 08:11 AM Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM Cowtoon Excel Worksheet Functions 9 November 12th 04 10:06 PM stge Excel Worksheet Functions 1 November 9th 04 05:39 PM

All times are GMT +1. The time now is 11:29 PM.