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