View Single Post
 
Old 04-28-2018, 12:20 AM
Gyabaabonsu Gyabaabonsu is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2018
Posts: 6
Gyabaabonsu is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Don't know what you mean by your second sentence.

It would have been more helpful if you showed what result you expect, based on the above numbers.

=sumproduct(small($a$1:$k$1,column($a:$f)))
For example
A B C D E F G H I J K
1 6 4 2 6 1 2 4 3 2 1 5
2 4 5 5 2 2 6 1 3 1 2 5
3
4
I want to add the lowest 6 numbers from the sheet above
From the first column I want excel to add any small numbers but the first 6 from A1 to K1

I want to add 1 1 2 2 3 4 from the first row
And 1 1 2 2 2 3 from the second row
Reply With Quote