Issue with Solver

Dear all,

I will try to describe the issue that i have with Solver:

I have random amounts in 2 scenarios and I am trying to find a particular target amount, which is a sum of count (x) of amounts from 2 lists – with 16 and 24 amounts

Now, the solver is working just fine with the 16 amounts, but when trying with 24 amounts, it is not able to find the particular amount I am looking for, but is finding a slightly different result with tolerance and I am searching for this very amount. I am using GRG Nonlinear method without automatic scaling. The variable cell is SUMPRODUCT function of 2 arrays, the first one with the amounts, the other one is "0"

attached is the file with both scenarios

Any help will be greatly appreciated and hope I have explained myself well.
thanks

but it cant find a solution for the 24 rows so maybe there isnt one!

According to the OP

to find a particular target amount, which is a sum of count (x) of amounts from 2 lists – with 16 and 24 amounts

I would assume there is.

Is this what you want? I can't get the constraints to work with it though.

Check Solver -> Options -> "All Methods" if box "Ignore Integer Constraints" is ticked untick it and try again.

My "best" result after sorting values smales to largest and setting "Integer Otimality %" to 0 was -916235.59 (see png file). Tested going from 5 % to 0 % on "Integer Optimlity %" but same result each time.

Problem may be to complex for Solver?

Alf

Thank you all guys for the efforts!

yes, there are x amounts that total both the target amounts for the respective scenarios, that's true. Unfortunately I have to find those particular amounts and it seems solver is not working properly with a bigger number of amounts - I have tried various scenarios with over 20 amounts and could not find the solution to none of them. Sometimes it takes too much time and with the 16 amount scenario it takes a minute, so it is very odd for me. Attached is the solved 16 amount scenario so you can get a better picture of what exactly I am trying to find.

thanks

Probably a bit late but yes there is a solution as the OP said (see Solver_Solution.png)

Alf