Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with a function I'm not sure exists
I want excel to sum the highest 5 numbers in a row of 20-25. This means it'll first need to find 5 highest values and then add 'm up. Example: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 would be 20+19+18+17+16 = 90 Does excel allow for an easy way to do this automatically, or do I have to do this manually? Thanks in advance -- Cervantes ------------------------------------------------------------------------ Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323 View this thread: http://www.excelforum.com/showthread...hreadid=395944 |
#2
|
|||
|
|||
for the five highest in row 1 (columns a:z) =SUM(LARGE(A1:Z1,{1,2,3,4,5})) entered with control+shift+enter -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=395944 |
#3
|
|||
|
|||
duane Wrote: for the five highest in row 1 (columns a:z) =SUM(LARGE(A1:Z1,{1,2,3,4,5})) entered with control+shift+enter hm, I get some kind of error message, saying the formula has an error. The cursor is on z1 after the error message... -- Cervantes ------------------------------------------------------------------------ Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323 View this thread: http://www.excelforum.com/showthread...hreadid=395944 |
#4
|
|||
|
|||
the formula works fine for me as long as i have data in that range -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=395944 |
#5
|
|||
|
|||
Just enter will do.
duane wrote: for the five highest in row 1 (columns a:z) =SUM(LARGE(A1:Z1,{1,2,3,4,5})) entered with control+shift+enter |
#6
|
|||
|
|||
I think my dutch excel doesn't understand the english terms, so I'm gonna have another look in the help file. But thanks cause you helped look in the right direction. -- Cervantes ------------------------------------------------------------------------ Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323 View this thread: http://www.excelforum.com/showthread...hreadid=395944 |
#7
|
|||
|
|||
Cervantes,
Try =SOM(GROOTSTE(A1:Z1;{1;2;3;4;5})) -- HTH RP (remove nothere from the email address if mailing direct) "Cervantes" wrote in message ... I think my dutch excel doesn't understand the english terms, so I'm gonna have another look in the help file. But thanks cause you helped look in the right direction. -- Cervantes ------------------------------------------------------------------------ Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323 View this thread: http://www.excelforum.com/showthread...hreadid=395944 |
#8
|
|||
|
|||
Bob Phillips Wrote: Cervantes, Try =SOM(GROOTSTE(A1:Z1;{1;2;3;4;5})) -- HTH RP [/color] yeah, that's it, thanks. stupid dutch version, i don't know why i have it on my system ;) -- Cervantes ------------------------------------------------------------------------ Cervantes's Profile: http://www.excelforum.com/member.php...o&userid=26323 View this thread: http://www.excelforum.com/showthread...hreadid=395944 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |