View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jack Daniels
 
Posts: n/a
Default 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=508305