Finding what group of numbers that equal a set amount.

Occasional Visitor

Hello,

I have several customers that pay by invoice instead of statement. They have balances older than 90 days, but not as old as 120 days. I have all their invoices from the time frame in question on a spreadsheet. I have the invoice dollar amounts in A2 through A34, with their corresponding Invoice Numbers in D2 through D34. I have the Target Amount in F2. What I am trying to do is see what combination of invoices would total the Target Amount. I am using Microsoft 365 with the Solver add-in turned on.  I'm thinking it should be fairly simple, but I am stumped. 

Thank you for any assistance,

William

 

0 Replies