Hi, I'm new to this thread but have a question that could really help with a project I am working on.

To describe the project, I am going through numerous different company invoices and marking off the specific ones as they are paid so we know what invoices remain unpaid. I go about this by getting a check such as $21,992.21. I then go to the company invoice section and find that this $21,992.21 can be made up of many different payments. I copy all the payments and paste them into excel going through and highlighting them together to see which ones will add up to $21,992.21.

This isn't that bad when the invoices look like...

5,435.82
5,428.83
3,761.74
5,447.71
5,467.98
5,530.92
5,545.60
4,242.71
4,242.71

Because I can highlight easy go through and see that the 4th 5th 6th and 7th add up to $21,992.21. It gets more difficult when I have a company that has 100 + payments so the process takes much longer.

Is there a formula that may autosum each column and then I can use "command F" to search for the invoice check amount in order to find these specific payments faster?

Thank you for any help