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