Excel - find a sum with a list of numbers

[alisapooh]

I have a list of say 20 numbers. The total sum could be anything - i need to find a certain sum using an unknown combination of the numbers. How would I do that?

Ex:
($422.00)
($1,191.39)
($391.13)
($510.00)
($96.35)
($1,931.00)
($504.00)
($738.27)
($2,604.38)
($1,728.99)
($9,247.20)
($43.00)
($5,695.46)
($1,191.39)
($5,614.24)
($1,365.00)
($504.00)
($1,709.82)
($8,088.88)
($16.22)
($59.50)
($9,282.40)

What combination of these numbers would sum to ($7,921.29)?

 

[macropod]

Hi alisapooh,

See:

http://www.tek-tips.com/faqs.cfm?fid=4742

and:

http://www.tek-tips.com/viewthread.cfm?qid=1485698

Cheers
[MS MVP - Word]

 

[alisapooh]

I don't have Solver in the tools dropdown

 

[pjm]

Tools/Add-Ins - and check the Solver Add-in

pjm

 

[alisapooh]

Thank you all!! It finally worked!! That Solver add in is awesome!

 

[SkipVought]

"Solve - ed!" as Inspector Jacques Clouseau would say.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]