Hi,

Yes it can. Put the numbers you have in a column and add a column of zeros
next to them, and calculate =SUMPRODUCT () between the two. This becomes the
target cell for solver.

The cells to change are the columns of zeros and then you "just" have to add
the constraint that each of these is binary.

Finally, set solver to do Equal to Value of 79 in your example.

In this case I get the solution 51 + 28 btw!

HTH,

David

"chrisrowe_cr" wrote:


Hi everyone, im new here. I have a reasonable knowlege of Excel, but my
question emphasises a gap in my knowledge!

ok, wondering if and how the solver function could achieve this:

list of numbers...

23
43
51
27
19
28

etc....

I want to find say for example the numbers that add upto 79 in that
list, can solver find which of the numbers ie 43+17+19 do so?


--
chrisrowe_cr
------------------------------------------------------------------------
chrisrowe_cr's Profile: http://www.excelforum.com/member.php...o&userid=25220
View this thread: http://www.excelforum.com/showthread...hreadid=387084