|
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 |
Sum of a range dont have to be over 8
Try this:
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 "Jack Daniels" wrote: 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 |
| All times are GMT +1. The time now is 02:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com