Solved Identify numbers that add up to a specific number.

March 25, 2014 at 11:51:43
Specs: Windows 7
I have 46 numbers and I know that 34 of those numbers equal up to a certain total number. What can I use in excel to identify those 34 numbers.

See More: Identify numbers that add up to a specific number.

Report •


#1
March 25, 2014 at 12:47:56
✔ Best Answer
Try the technique found at the following link. It should find a set of numbers that add up to your total. Whether it find the exact 34 that you are looking for will depend on whether or not there are more than one set of set numbers that SUM to that total.

For example, if I have these 8 numbers and want to find which ones SUM to 6, the technique shown will only find 1 set when there are techically multiple sets.

1, 2, 2, 2, 2, 1, 3, 3

In any case, it's pretty neat. Hopefully it will find the 34 numbers that you are looking for.

http://www.k2e.com/tech-update/tips...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 27, 2014 at 12:09:09
This was a good answer. However I still wonder if there is a way to tell Excel to look for a certain number of items that will equal a specific number.

Report •

#3
March 27, 2014 at 15:16:47
Not without some complicated VBA to continually SUM various combinations of 34 numbers until the desired result is found.

What is the purpose of this exercise?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question