What combination of numbers in a series sums to a specific value?

[Ashley]

How do I find what combination of numbers in a series sums to a specific
value? I have the end sums and a list of values, some of which may be used
and some of which may not, and I need a way to add the values in whatever
combinations to equal all the sums.

 

[Max]

Check out this Tom Ogilvy classic for a way using Solver:
http://tinyurl.com/5kx9bw

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Ashley]

Extraordinary! Thanks so much, Max. It worked like a charm for all three of
my sums.

Ashley