I am new to solver, and am trying to find a solution using a column of
numbers. Basically I want to find the sum of 4311.20 in a list of numbers .

My target cell has the formula =sumproduct(actuals,ones) where actuals is
the name of the cells to use for the solution, and ones is for the binary
number.

In solver I am selected the target cell with the formula, value = to
4311.20, by changing cells has the word "ones" for the column with ones in
it, and the constraints are ones=binary. I get the error message "Too many
adjustable cells".

Solver... I get the error message "Too many
adjustable cells".

Hi. The Solver that comes with Excel is limited to 200 Changing Cells.

= = = = =
HTH
Dana DeLouis


dee wrote:
I am new to solver, and am trying to find a solution using a column of
numbers. Basically I want to find the sum of 4311.20 in a list of numbers .

My target cell has the formula =sumproduct(actuals,ones) where actuals is
the name of the cells to use for the solution, and ones is for the binary
number.

In solver I am selected the target cell with the formula, value = to
4311.20, by changing cells has the word "ones" for the column with ones in
it, and the constraints are ones=binary. I get the error message "Too many
adjustable cells".