software

Hi!

I have a workshhet where people are booking themselves for different
programs. But there is a limit, for example the SUM of D210 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: www.excelforum.com/member.php...oamp;userid=31170
View this thread: www.excelforum.com/showthread...hreadid=508305Try this:

Select D210, then go to Data/Validation, next select quot;customquot; from the
quot;Allowquot; menu and in the formula box type:

=SUM($D$2:$D$10)lt;=8

next click on the quot;Error Alertquot; tab and leave a message for the user.

HTH
JG

quot;Jack Danielsquot; wrote:

gt;
gt; Hi!
gt;
gt; I have a workshhet where people are booking themselves for different
gt; programs. But there is a limit, for example the SUM of D210 don´t
gt; have to be more than 8. How do I stop a user to put in any number when
gt; th SUM has reached 8?
gt;
gt; Jack
gt;
gt;
gt; --
gt; Jack Daniels
gt; ------------------------------------------------------------------------
gt; Jack Daniels's Profile: www.excelforum.com/member.php...oamp;userid=31170
gt; View this thread: www.excelforum.com/showthread...hreadid=508305
gt;
gt;