Excel formula help needed

%3CLINGO-SUB%20id%3D%22lingo-sub-2311431%22%20slang%3D%22en-US%22%3EExcel%20formula%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2311431%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20putting%20together%20an%20excel%20sheet%20for%20a%20golf%20tournament%20we%20are%20going%20here%20on%20campus.%26nbsp%3B%20There%20are%20teams%20of%205%20golfers%2C%20but%20only%20the%204%20lower%20scores%20count.%26nbsp%3B%20How%20can%20I%20set%20up%20a%20formula%20that%20will%20examine%20the%20range%20of%20the%20scores%20in%20the%205%20cells%2C%20but%20will%20only%20total%20up%20the%204%20lowest%20scores%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assume%20I%20will%20be%20using%20a%20sumif%20formula%2C%20but%20I%20am%20stuck%20here%20at%20this%20point.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStuart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2311431%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2311447%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2311447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041806%22%20target%3D%22_blank%22%3E%40spearce%3C%2FA%3E%26nbsp%3BSuppose%20your%205%20scores%20are%20in%20A1%3AA5%2C%20use%20this%20to%20sum%20the%20top%204%20scores.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(LARGE(A1%3AA5%2C%7B1%2C2%2C3%2C4%7D))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2311534%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20help%20needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2311534%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much%20-%20that%20worked%20splendidly!!!%3C%2FLINGO-BODY%3E
New Contributor

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

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

 

Thank you very much - that worked splendidly!!!

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

@spearce 

I guess misprint, for lowest scores

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

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

 

@Riny_van_Eekelen , you better know golf