View Single Post
 
Old 04-26-2018, 04:36 PM
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
=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 a to k
Reply With Quote