Assuming the sum is in C1, add data validation with a custom formula in the
cells, a formula of =$C$1<=10

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Amy Stein" wrote in message
oups.com...
I have a worksheet with a range of cells that have a SUMIF function
based on entry into another range of cells. How can I prevent user
entry that will cause these cells to exceed the value of 10?


Thanks in advance for any help.


Amy