Help to find numbers that equal a predetermined sum

LLL

New member
Joined
Jun 24, 2013
Messages
1
Reaction score
0
Points
0
This may be an odd question and I hope I can explain it clearly. Is there a formula that would identify numbers in a column where the sum of those numbers would equal a predetermined amount? For instance, if my office receives a payment from a customer for $1275, and the customer has numerous invoices open where some combination of some of those invoices equals $1275, is there a formula to find that? And in doing so I would know which invoices I could apply the payment to without having any leftover amount from the payment.
 
Top