Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Possible to pick out the lowest eight numbers in a row?
Have Excel 2003. I have a row of about 30 columns width.
See http://www.puck.no/skien/SK221204resultat.gif for a picture of my sheet. The numbesr represent points scored in a league. I want the total-column to just add up all the points, and then deduct automatically the eight lowest figures. Possible? Thanks |
#2
|
|||
|
|||
Use the SMALL() function.
Suppose your data is in A1:A40. In B1:B8, set up a series of number from 1 to 8. In C1 enter the formula =SMALL($A$1:$A$40,B1) Fill down to C8. Your formula: =SUM(A1:A40)-SUM(C1:C8) -- Kind Regards, Niek Otten Microsoft MVP - Excel "Christian Borchgrevink-Vigeland" wrote in message ... Have Excel 2003. I have a row of about 30 columns width. See http://www.puck.no/skien/SK221204resultat.gif for a picture of my sheet. The numbesr represent points scored in a league. I want the total-column to just add up all the points, and then deduct automatically the eight lowest figures. Possible? Thanks |
#3
|
|||
|
|||
Hi
try the following formula: =SUM(A1:X1)-SUMPRODUCT(SMALL(A1:X1,ROW(INDIRECT("1:8")))) -- Regards Frank Kabel Frankfurt, Germany Christian Borchgrevink-Vigeland wrote: Have Excel 2003. I have a row of about 30 columns width. See http://www.puck.no/skien/SK221204resultat.gif for a picture of my sheet. The numbesr represent points scored in a league. I want the total-column to just add up all the points, and then deduct automatically the eight lowest figures. Possible? Thanks |
#4
|
|||
|
|||
Another way:
=SUM((A1:AD1),-(SMALL(A1:AD1,{1,2,3,4,5,6,7,8}))) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Christian Borchgrevink-Vigeland" wrote in message ... Have Excel 2003. I have a row of about 30 columns width. See http://www.puck.no/skien/SK221204resultat.gif for a picture of my sheet. The numbesr represent points scored in a league. I want the total-column to just add up all the points, and then deduct automatically the eight lowest figures. Possible? Thanks |
#5
|
|||
|
|||
Superfluous parenthesizes:
=SUM(A1:AD1,-SMALL(A1:AD1,{1,2,3,4,5,6,7,8})) -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "RagDyeR" wrote in message ... Another way: =SUM((A1:AD1),-(SMALL(A1:AD1,{1,2,3,4,5,6,7,8}))) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Christian Borchgrevink-Vigeland" wrote in message ... Have Excel 2003. I have a row of about 30 columns width. See http://www.puck.no/skien/SK221204resultat.gif for a picture of my sheet. The numbesr represent points scored in a league. I want the total-column to just add up all the points, and then deduct automatically the eight lowest figures. Possible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |