Home

adding up cells

%3CLINGO-SUB%20id%3D%22lingo-sub-543663%22%20slang%3D%22en-US%22%3Eadding%20up%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-543663%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%206%20cells%20that%20I%20want%20to%20sum%20up%20the%20top%204%20in%20value.%20How%20can%20this%20be%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-543663%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-543705%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20up%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-543705%22%20slang%3D%22en-US%22%3EIf%20the%20cells%20you%20want%20to%20sum%20are%20in%20A2%3AA7%2C%20you%20may%20use%20this%20formula%20to%20get%20the%20sum%20of%20the%20top%204%3A%3CBR%20%2F%3E%3DSUMPRODUCT(LARGE(A2%3AA7%2CROW(1%3A4)))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-565035%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20up%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565035%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20will%20give%20it%20a%20try%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-565091%22%20slang%3D%22en-US%22%3ERE%3A%20adding%20up%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565091%22%20slang%3D%22en-US%22%3E%3CP%3ESince%20I%20currently%20on%20the%20Office%20365%20machine%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20SUM(%20LARGE(%20values%2C%20SEQUENCE(4)%20)%20)%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20SUMIFS(%20values%2C%20values%2C%20%22%26gt%3B%3D%22%26amp%3BLARGE(values%2C4)%20)%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20SUM(%20FILTER(%20values%2C%20values%26gt%3B%3DLARGE(values%2C4))%20)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eadd%20a%20bit%20of%20variety.%20Despite%20the%20choice%2C%20I%20think%20I%20will%20go%20with%20the%20first%20to%20avoid%20problems%20with%20tied%204th%20places.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-565177%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20up%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565177%22%20slang%3D%22en-US%22%3EPlease%20do%20try%20it%20and%20update%20me%20thereafter.%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I have a column of 6 cells that I want to sum up the top 4 in value. How can this be done?

 

4 Replies
If the cells you want to sum are in A2:A7, you may use this formula to get the sum of the top 4:
=SUMPRODUCT(LARGE(A2:A7,ROW(1:4)))

Thank you will give it a try@Twifoo 

Since I currently on the Office 365 machine

= SUM( LARGE( values, SEQUENCE(4) ) )

= SUMIFS( values, values, ">="&LARGE(values,4) )

= SUM( FILTER( values, values>=LARGE(values,4)) )

add a bit of variety. Despite the choice, I think I will go with the first to avoid problems with tied 4th places.

Please do try it and update me thereafter.