Is there a Best Of Function in Excel?
 

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

Is there a Best Of Function in Excel?
 

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)

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

Is there a Best Of Function in Excel?
 

You have to build your own

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


--

Regards,

Peo Sjoblom




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