Add best 6 numbers on a row of 10

xor · #1 04-22-2018, 08:41 PM

=sumproduct(small($a$1:$k$1,column($a:$f)))

Gyabaabonsu · #2 04-26-2018, 04:36 PM

Quote:

Originally Posted by xor

=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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Help Deleting Numbers in Hour Format and Numbers in Sequence	rsrasc	Word VBA	1	10-12-2016 02:49 PM
How do I edit my TOC to reference the section numbers instead of the page numbers???	mikey386	Word	0	12-17-2014 02:34 PM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
How to change the formatting of numbers without changing the numbers?	sullengirl	Word	2	01-27-2014 03:06 PM
How do I refer to page numbers, when the numbers change as I prepare the document?	StevenD	Word	5	11-29-2012 12:52 AM