Sum of a range dont have to be over 8
 

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=508298

Sum of a range dont have to be over 8
 

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 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


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=508298

Sum of a range dont have to be over 8
 

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: http://www.excelforum.com/member.php...o&userid=31170
View this thread: http://www.excelforum.com/showthread...hreadid=508298