SUM

Copper 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,