View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DEE DEE is offline
external usenet poster
 
Posts: 250
Default what does error message "too many adjustable cells" mean in solver

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".