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 22, 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.

mike smith's avatar
mike smith
Copper Contributor
May 23, 2018
You Sir, are a saviour and a gentleman. The formula works perfectly. Many thanks for your contribution.
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 23, 2018

Glad you were able to get it working.  You're welcome.  Please feel free to post back to the community with any other inquiries!