finding a sum from a list

[SBUMP2]

I have a list of 10 numbers in column A.

I am given a number and told that there are a combination of numbers (2 or
more) from column A that sum to that number.

Is there anyway I can set up a formula for this?

 

[Paul Corrado]

http://groups.google.com/[email protected]&rnum=1

Take a look at Tom Ogilvy's solution for this problem.

PC