As an FYI to the OP... using Large will count duplicate entries as
separate entries.

Example:
---A-B-C-D-E
1]8,8,8,7,6

=SUM(LARGE(A1:E1,{1,2,3})) will return 24 not 21 as you may expect. 8
is not only the #1 Large number, it is also the #2 and #3 Large
number.


HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=392661