I work in accounts recievables. Some of the checks that I recieve are
$200,000.00, with hundereds of invoices referenced. People never pay
invoices in line or by date, which make it very time consuming to post cash.

I was wondering if you can take a persons account with all the open
invoices which could total $446,98.00, and take there check which totals
$298,987.89 run a formauls which would find all the invoices that would total
that particular amount? Say if I had $298,897.89, i type that in my formula
and excel would give me all the invoces that would add to that total? I hope
this makes sense? Is there any why of doing this? It would save me a lot of
time and I would greatly appreciate it. Thank you for your time.

Isaac