There is not a specific formula to do this that I am aware
of. It sounds like you would have to write a routine. It
wouldn't be too bad, but would consist of quite a few
nested Do loops (at least in my limited knowledge). And
depending on the complexity, it most likely would return
only one subset that equals the target sum, even if
multiple subsets would satisfy the goal.

-----Original Message-----
I have a column of numbers that I need to find only a
subset that adds up to a specific value. Is there a
formula to do this? Ex: A1 through A1 thru A24 equals
3899 but I need to find only 5 fields that add up to 640.
.