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.

Try the technique found at the following link. It should find aset 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.

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.

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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History