how to constrain the sum of a range in solver

A

a.raney

How do I add a constraint which limits the sum of a range ie I have 2000
leaflets to split between 3 mailshots. I have tried sum(C1:C3)<=2000 but just
get nonsense as answer
 
B

Bob Phillips

Use Data>Validation, with a custom type and a formula of
=SUM($C$1:$C$3)<=2000, in all 3 cells.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
T

Tushar Mehta

How do I add a constraint which limits the sum of a range ie I have 2000
leaflets to split between 3 mailshots. I have tried sum(C1:C3)<=2000 but just
get nonsense as answer
Click to expand...
What does "just get nonsense" mean? One of the things to try is in C4 add
the formula =SUM(C1:C3). Then, in Solver, specify C4 <= 2000

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top