What numbers in list add to ????

[thewaksta]

Hi All,

I would have searched this question because I'm sure it's been asked before but no idea how to word the search. I have a list of numbers:

-1066.52
-5219.44
-3323.23
-2346.5
-1477.5
-302.5
-175.96
-167.5
-76.54
-62.23
-62.2
1952.25
-3934.45
-1765.34
-949.2
-669.9
-213.9
-211.2
-168
-91.2
-72
-70
-60
-50
-30
-1520
-893.5
-816.21
-760.01
-475
-211.2
-200

and would like to know a way to say - look at this list and tell me if any combination of them will sum to 13273.91. This is something I have to do quite a lot and figure there must be an easier way than just searching through them constantly.

Thanks

 

[JamesW]

Hi,

The Solver Addin will do this for you:

http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[VoG]

Hi. See if this helps http://www.tushar-mehta.com/excel/templates/match_values/index.html

 

[thewaksta]

Thanks for the quick replies. I've tried to use solver and the template in the past but i always get a wierd answer like this number and this number and 2.7659 of this number. How do i set Solver to look at the list and only return whole numbers or an answer saying no combination exists?

Cheers
Waka