Forum Discussion

mike smith's avatar
mike smith
Copper Contributor
May 22, 2018
Solved

Excel newbie

Hi. I’m trying to run a sports type league where competitors are awarded points at the end of every event. 1 point per position, lowest score wins the league. There are 10 events, which are added in t...
excel
Formulas and Functions
  • Matt Mickle's avatar
    Matt Mickle
    May 23, 2018

    Mike-

     

    Try using this formula: 

     

    =SUM(C4:L4)-LARGE(C4:L4,1)-LARGE(C4:L4,2)

     

    Your data should look something like this....

     

     

    Please see the attached file for further reference.  Hope this helps.

John Jairo Vergara Domínguez's avatar
John Jairo Vergara Domínguez
Brass Contributor
May 23, 2018

Hi, to all!

 

You can use too (in Matt's File):

=SUMPRODUCT(SMALL(C4:L4,ROW($1:$8)))

or

=SUM(C4:L4,-LARGE(C4:L4,{1;2}))

 

Blessings!

 

Resources