 # Excel formula help needed

Good day!

I am putting together an excel sheet for a golf tournament we are going here on campus.  There are teams of 5 golfers, but only the 4 lower scores count.  How can I set up a formula that will examine the range of the scores in the 5 cells, but will only total up the 4 lowest scores?

I assume I will be using a sumif formula, but I am stuck here at this point.

Stuart

6 Replies

# Re: Excel formula help needed

@spearce Suppose your 5 scores are in A1:A5, use this to sum the top 4 scores.

``=SUM(LARGE(A1:A5,{1,2,3,4}))``

# Re: Excel formula help needed

Thank you very much - that worked splendidly!!!

# Re: Excel formula help needed

@spearce Great! Happy golfing. Looking forward to the season here. Still at least one month away.

# Re: Excel formula help needed

I guess misprint, for lowest scores

``=SUM(SMALL(A1:A5,SEQUENCE(4)))``

# Re: Excel formula help needed

@Sergei Baklan Mmmmmm, somehow I read lowest score as highest points. Guess I was wrong, but the principle is the same.

``=SUM(SMALL(A1:A5,{1,2,3,4}))``

# Re: Excel formula help needed

@Riny_van_Eekelen , you better know golf