Home 
Search 
Today's Posts 
#1




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




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




=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




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




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




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 
Display Modes  


Similar Threads  
Thread  Forum  
what formula do i put for column m = column k minus column l in e.  Excel Discussion (Misc queries)  
how to enter a formula using column() function for a range  Excel Worksheet Functions  
GET.CELL  Excel Worksheet Functions  
Need number of months or weeks passed from formula  Excel Worksheet Functions  
Req, Tricky column formula  Excel Worksheet Functions 