#1
|
|||
|
|||
Add best 6 numbers on a row of 10
Am trying to add any best 6 smallest in a row |
#2
|
|||
|
|||
Not understood!
|
#3
|
|||
|
|||
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 3 4 I want to add the lowest 6 number from the sheet above |
#4
|
|||
|
|||
=sumproduct(small($a$1:$k$1,column($a:$f)))
|
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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. |
#7
|
||||
|
||||
Is this it?
=SUMIF(A1:K1,"<="&SMALL(A1:K1,6)) copied down |
#8
|
|||
|
|||
Quote:
=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 |
#9
|
|||
|
|||
Why not 1 1 2 2 2 3 (total 11) from the first row?
If I am right then that's exactly what my formula in #4 does. =SUMPRODUCT(SMALL(A1:K1,COLUMN($A:$F))) |
#10
|
|||
|
|||
Quote:
Without arrange them. From the table above the ones 1 1 2 2 2 3 which is (11) But from your formula $A:$F Meaning from A to F but I want excel to check A to K and select any six small numbers and add them |
#11
|
|||
|
|||
Please It didn't work
|
#12
|
|||
|
|||
Why is it so difficult for you then to tell what the result should be (exact numbers please)! And it would be fine with more than just two examples.
By the way, your last sentence seems to demonstrate that you don't understand the formula. |
|
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 |