Try this:

Select D2:D10, then go to Data/Validation, next select "custom" from the
"Allow" menu and in the formula box type:

=SUM($D$2:$D$10)<=8

next click on the "Error Alert" tab and leave a message for the user.

HTH
JG

"Jack Daniels" wrote:


Hi!

I have a workshhet where people are booking themselves for different
programs. But there is a limit, for example the SUM of D2:D10 don´t
have to be more than 8. How do I stop a user to put in any number when
th SUM has reached 8?

Jack


--
Jack Daniels
------------------------------------------------------------------------
Jack Daniels's Profile: http://www.excelforum.com/member.php...o&userid=31170
View this thread: http://www.excelforum.com/showthread...hreadid=508305