how to constrain the sum of a range in solver
 

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
--
alanr

how to constrain the sum of a range in solver
 

Use DataValidation, 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)

"a.raney" wrote in message
...
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
--
alanr

how to constrain the sum of a range in solver
 

In article ,
says...
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

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