I am trying to use the Solver tool to find multiple amounts that equal a specific amount. This worked one time for me and now I can never get Solver to find a solution, when I know there is one. In the screenshot, the highlighted amounts equal the sum of the amount I am looking for, but when I run solver it says there is no solution. What am I doing wrong??
Are you looking for value 21.452,07 in cell J34? I've changed the target value in the solver parameters and it works in my sheet. In the sheet there are a few formulas for example
=SUM(M22:M28)in cell M29.
