Is there a Best Of Function in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
Back
Top