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