Excel formula help needed

[spearce]

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

[#2]

@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}))

[#3]

Thank you very much - that worked splendidly!!!

[#4]

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

[#5]

@spearce 

I guess misprint, for lowest scores

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

[#6]

@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}))

[#7]

@Riny_van_Eekelen , you better know golf