SUM

%3CLINGO-SUB%20id%3D%22lingo-sub-2171092%22%20slang%3D%22en-US%22%3ESUM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171092%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20make%20a%20sum%20to%204%20higest%20numbers%20out%20og%206%20numbers%20in%20in%20many%20columns%20where%20the%20numbers%20are%20not%20in%20the%20same%20order%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2171092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2171157%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F980716%22%20target%3D%22_blank%22%3E%40Baldur1912%3C%2FA%3E%26nbsp%3BSomething%20like%20this%20perhaps%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-27%20at%2016.41.27.png%22%20style%3D%22width%3A%20475px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258651iBB25E0ACDBD9BB91%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-27%20at%2016.41.27.png%22%20alt%3D%22Screenshot%202021-02-27%20at%2016.41.27.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20not%2C%20please%20upload%20an%20example%20that%20resembles%20you%20real%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2171254%22%20slang%3D%22en-US%22%3ERe%3A%20SUM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20answer.%20It%20is%20like%20that.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Baldur1912_0-1614442267818.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258653i9D13A483FE6D9FBB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Baldur1912_0-1614442267818.png%22%20alt%3D%22Baldur1912_0-1614442267818.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How do I make a sum to 4 higest numbers out og 6 numbers in in many columns where the numbers are not in the same order

 

4 Replies

@Baldur1912 Something like this perhaps?

Screenshot 2021-02-27 at 16.41.27.png

If not, please upload an example that resembles you real data.

@Riny_van_Eekelen 

Thanks for the answer. It is like that.

Baldur1912_0-1614442267818.png

 

@Baldur1912 Okay! Misread your question thinking that you wanted to add numbers across columns. Never mind! The formula is much the same. See attached.

 

thanks so much,