# Using Excel to determine a combination of numbers that equal a set total

1. ## Using Excel to determine a combination of numbers that equal a set total

Is there anyway to use Excel to determine which of a set of numbers equals a total? I encounter this issue when dealing with accounts receivable. We receive payments with no details on what is being paid. I have a list of open items and a total being paid. I would like to have Excel determine which combination of invoices can be added together to match the payment. Not sure if this can be done but thought I would ask. I appreciate any help that can be provided.

Thanks,
DaveBab  Register To Reply

2. ## Re: Using Excel to determine a combination of numbers that equal a set total

Check this post, it came from a few years back but it's a similar problem to what you are having. However, I would think it probably does not help too much if you are dealing with account receivable since you are probably looking at hundreds and thousands of data. Good luck.

http://www.excelforum.com/excel-work...for-a-sum.html  Register To Reply

3. ## Re: Using Excel to determine a combination of numbers that equal a set total

See http://www.tushar-mehta.com/excel/te...ues/index.html  Register To Reply

4. ## Re: Using Excel to determine a combination of numbers that equal a set total

Thank you! This is a great feature. I typically have somewhat smaller data sets (~50), so it takes a bit to run, but can be very helpful. One question on the instructions. There is a formula B2:B100=0 in the example. Where would this be used? I couldn't find it in the solver spreadsheet example that was provided.

Thanks,
DaveBab  Register To Reply

5. ## Re: Using Excel to determine a combination of numbers that equal a set total

go to this site: http://www.handyexcelmacros.net
Go to the Sum to target page  Register To Reply

6. ## Re: Using Excel to determine a combination of numbers that equal a set total

I wish to delete the above comments now because the website http://www.handyexcelmacros.net will be going down soon. Dredge.  Register To Reply

7. ## Re: Using Excel to determine a combination of numbers that equal a set total

This seems to me to be the same as that placed in the post http://www.excelforum.com/search.php?searchid=4467096
and for which I presented an Excel array formula for a sub-list of 9 elements  Register To Reply

8. ## Re: Using Excel to determine a combination of numbers that equal a set total

Hi

See the file Sample_6.xlsx

Regards  Register To Reply

9. ## Re: Using Excel to determine a combination of numbers that equal a set total

Jose, you are responding to a really old thread, I doubt any members are still following it  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1