Forum Discussion
HELP! Using Solver
Please look at attachment and help me with using solver, I've only done it once and not sure how to work it for the below scenario. It is on sheet called "Solutions to New Store Locations" The ob...
The formula in C42 should be =SUMIF(B4:B40,1,C4:C40) since you only want to include stores that have a 1 in column B.
The constraints should be:
B4:B40 is integer
B4:B40 is greater than or equal to 0
B4:B40 is less than or equal to 1
B42 should be equal to 4 (exactly 4 stores)
