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