Find cells in a range that sum to an amount

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a spread*** of invoices with invoice numbers and amounts for
clients. Sometimes I get a check with an amount for some of the invoices,
but I don't know which invoices the check goes with. Is there a function or
add-in that can look at all the invoice amounts and find one or more that add
up to the check amount?

I realize there would be cases where more than one answer would result, but
I would be happy to get any answer that works.

Is there an add-in or other code to help me do this?

Thank you for any help on this!


--
Daryl S
.

Quantcast