Sum of 2 cells in a column equal a specific number

[philippe1]

I am looking for a formula that would locate 2 cells in a column of numbers.
The sum of these 2 cells should equal a specific number (456 for example).
Thank you for your help.

[Haseeb Avarakkan]

Hello Philippe1, Welcome to the forum!

Please attach a sample file with expecting result..!

[philippe1]

Hi, Attached is a excel file with a simple example of what I am looking for.
Thanks.

[Mordred]

Let me know if this works for you:

Please Login or Register  to view this content.

[Mordred]

Here's one with a button to activate the sum formula.

[philippe1]

Thank you Mordred, it works fine, thanks for the time spent to create this code. It will save me a lot of time.

[Mordred]

Hi philippe, see if the next workbook is better or not. It places the found number to the right of both numbers being added.

[Mordred]

The solution I provided to you works but does take some time if there are thousands of rows. I just tested it on 5000 rows and it took about 1 minute to complete.

[philippe1]

Thanks Mordred, this new version is even better, my rows are about 1000, so it is working fine.
I guess we can consider this thread SOLVED but I don't know how to do that since I am new to this forum.

[abishekmouli88]

Hello,

Please find the attached file and see if it helps. This gives you the sum you need and also the address of the sum of cells. This can be done for any number of rows.

Thanks and Best Regards,
Abi

[philippe1]

Thanks Abi, your file works fine.