Apr 30 2021 09:17 AM
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
Apr 30 2021 09:23 AM
@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}))
Apr 30 2021 09:40 AM
@spearce Great! Happy golfing. Looking forward to the season here. Still at least one month away.
Apr 30 2021 09:42 AM
Apr 30 2021 09:45 AM
@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}))