Is there a Best Of Function in Excel?

V

VipinK

Does excel have a "best of" function - i.e. summing the best 3 out of 5 for
example?
 
R

Ron Coderre

If there may be less than 3 items..
try this:
=SUMPRODUCT(INDEX(LARGE(A1:A5,ROW($A$1:INDEX($A$1:$A$5,MIN(COUNT(A1:A5),3)))),0))

or...if there will ALWAYS be at least 3 items:
=SUMPRODUCT(LARGE(A1:A5,{1,2,3}))

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Top