Find and show sum of values that equal a specific number

Hi,

I am really stumped here and am hoping one of you can help me out.

So say I have a column containing 100, 1000, or even 10,000 rows of numbers and I want to find any and all combinations of numbers in that column that equals a specific number.

For example,

Column A
10
-9
3
3
89
-43
15


I want to know if any combination of those numbers equals, say 86, (which would be -9, 3, 3, and 89) and then identify those rows where the sum exists.

Any help would be much appreciated, Let me know if you need more details or I'm not clear enough.

Thanks!

Thanks MarvinP, this is a great start!

The numbers I am working with are dollar values, and in using the random formula, this can take a long time to find a specific number. Do you know if I can have 5 or so columns doing this search all at the same time? Basically run 5 times faster?

Thanks!