Excel Solver Constraint Not Working

[coral007]

Hi,

I'm struggling with the Excel Solver option.

I have a table, and want to have fixed constraints for the sum of each row; e.g. $D$15:$D$20 = 200.

However, Excel solves this putting 200 into each cell of that row. What is going wrong here?
(I'm solving for min. cost, each row cell is multiplied with a cost for that specific delivery type, if this info helps).

Many thanks
Coral

 

[Worf]

Welcome

See if this example helps:

bank accounts.xlsx
	A	B	C	D	E	F	G	H
35	Material	Product A	Product B	Product C	Product D	Available	Used	Left
36	M1	1	1	1	3	250	232	18
37	M2	3	1	1	2	220	220	0
38	M3	2	1	2	1	235	225	10
39	M4	1	5	2	2	875	875	0
40	M5	3	1	3	4	300	298	2
41
42	Unitary profit	$15,0	$30,0	$20,0	$25,0
43	Produced	2,0000000	159,0000000	23,0000000	16,0000000
44	Profit	$30,0	$4.770,0	$460,0	$400,0
45	Total produced	200
46	Total profit	$5.660,0
Sheet1

Cell Formulas
Range	Formula
G36:G40	G36	=[@[Product A]]*$B$43+[@[Product B]]*$C$43+[@[Product C]]*$D$43+[@[Product D]]*$E$43
H36:H40	H36	=[@Available]-[@Used]
B44:E44	C44	=C42*C43
B45:B46	B45	=SUM(B43:E43)