View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
a.raney
 
Posts: n/a
Default 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