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