Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2018, 08:44 AM
Gyabaabonsu Gyabaabonsu is offline Add best 6 numbers on a row of 10 Windows 7 64bit Add best 6 numbers on a row of 10 Office 2013
Novice
Add best 6 numbers on a row of 10
 
Join Date: Apr 2018
Posts: 6
Gyabaabonsu is on a distinguished road
Default Add best 6 numbers on a row of 10


Am trying to add any best 6 smallest in a row
Reply With Quote
  #2  
Old 04-22-2018, 11:16 AM
xor xor is offline Add best 6 numbers on a row of 10 Windows 10 Add best 6 numbers on a row of 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Not understood!
Reply With Quote
  #3  
Old 04-22-2018, 02:03 PM
Gyabaabonsu Gyabaabonsu is offline Add best 6 numbers on a row of 10 Windows 7 64bit Add best 6 numbers on a row of 10 Office 2013
Novice
Add best 6 numbers on a row of 10
 
Join Date: Apr 2018
Posts: 6
Gyabaabonsu is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Not understood!
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
Reply With Quote
  #4  
Old 04-22-2018, 08:41 PM
xor xor is offline Add best 6 numbers on a row of 10 Windows 10 Add best 6 numbers on a row of 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

=sumproduct(small($a$1:$k$1,column($a:$f)))
Reply With Quote
  #5  
Old 04-26-2018, 04:36 PM
Gyabaabonsu Gyabaabonsu is offline Add best 6 numbers on a row of 10 Windows 7 64bit Add best 6 numbers on a row of 10 Office 2013
Novice
Add best 6 numbers on a row of 10
 
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
  #6  
Old 04-26-2018, 09:20 PM
xor xor is offline Add best 6 numbers on a row of 10 Windows 10 Add best 6 numbers on a row of 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote
  #7  
Old 04-27-2018, 04:54 AM
NBVC's Avatar
NBVC NBVC is offline Add best 6 numbers on a row of 10 Windows 10 Add best 6 numbers on a row of 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Is this it?

=SUMIF(A1:K1,"<="&SMALL(A1:K1,6))


copied down
Reply With Quote
  #8  
Old 04-28-2018, 12:20 AM
Gyabaabonsu Gyabaabonsu is offline Add best 6 numbers on a row of 10 Windows 7 64bit Add best 6 numbers on a row of 10 Office 2013
Novice
Add best 6 numbers on a row of 10
 
Join Date: Apr 2018
Posts: 6
Gyabaabonsu is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
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
Reply With Quote
  #9  
Old 04-28-2018, 12:36 AM
xor xor is offline Add best 6 numbers on a row of 10 Windows 10 Add best 6 numbers on a row of 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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)))
Reply With Quote
  #10  
Old 04-28-2018, 10:08 PM
Gyabaabonsu Gyabaabonsu is offline Add best 6 numbers on a row of 10 Windows 7 64bit Add best 6 numbers on a row of 10 Office 2013
Novice
Add best 6 numbers on a row of 10
 
Join Date: Apr 2018
Posts: 6
Gyabaabonsu is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
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)))
I want the formula to randomly select any six small numbers on a row
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
Reply With Quote
  #11  
Old 04-28-2018, 10:11 PM
Gyabaabonsu Gyabaabonsu is offline Add best 6 numbers on a row of 10 Windows 7 64bit Add best 6 numbers on a row of 10 Office 2013
Novice
Add best 6 numbers on a row of 10
 
Join Date: Apr 2018
Posts: 6
Gyabaabonsu is on a distinguished road
Default

Quote:
Originally Posted by NBVC View Post
Is this it?

=SUMIF(A1:K1,"<="&SMALL(A1:K1,6))


copied down
Please It didn't work
Reply With Quote
  #12  
Old 04-28-2018, 11:36 PM
xor xor is offline Add best 6 numbers on a row of 10 Windows 10 Add best 6 numbers on a row of 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote
Reply



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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft