Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
havocdragon
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Jason Morin
 
Posts: n/a
Default

=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   Report Post  
Domenic
 
Posts: n/a
Default

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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Jack Sheet
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what formula do i put for column m = column k minus column l in e. jenniss Excel Discussion (Misc queries) 5 January 6th 05 09:18 PM
how to enter a formula using column() function for a range Mike Peter Excel Worksheet Functions 6 December 8th 04 08:11 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
Need number of months or weeks passed from formula Cowtoon Excel Worksheet Functions 9 November 12th 04 10:06 PM
Req, Tricky column formula stge Excel Worksheet Functions 1 November 9th 04 05:39 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"