Thread: Find various totals from list of numbers

We often get checks from a customer for an odd amount so you know they are paying specific invoices. Their list of invoices to be payed may include twenty or thirty different amounts (Col A), but the customer doesn't reference which ones they are paying with this check. If I enter the check amount in a cell (C1), is there any way to find which combination of amounts (from Col A) total up to match the amount in C1?

Good afternoon researcy

Originally Posted by researcy

If I enter the check amount in a cell (C1), is there any way to find which combination of amounts (from Col A) total up to match the amount in C1?

This kind of question crops up quite a lot.

Have a look at the solutions to these posts :
http://www.excelforum.com/excel-misc...the-total.html
http://www.excelforum.com/excel-prog...n-problem.html

HTH

DominicB

Thanks for the help. I can see the problems with exponential growth as the original list gets longer. We can call this 'closed'.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save