Quote:
Originally Posted by xor
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