Is there a Best Of Function in Excel?

[Guest]

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

 

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

 

[Peo Sjoblom]

You have to build your own

=SUM(LARGE(A1:A10,{1;2;3}))