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=508298
There seems to be a lag in the system today because I answered this post
on the microsoft newsgroup hours ago. I guess I'll just have to repost
it here so here it goes.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--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=508298
Thank you very much!!!
It works perfect!!!!

I tried almost the same but I must have written something wrong.

Jack--
Jack Daniels
------------------------------------------------------------------------
Jack Daniels's Profile: www.excelforum.com/member.php...oamp;userid=31170
View this thread: www.excelforum.com/showthread...hreadid=508298