My thread title may not be helpful; it's the best description I can concoct. I have attached my .xlsx file.
I am creating a polling sheet in which a user is allotted 70 "points" to distribute as desired among one or more candidates. He will type these "points" into cells in column B.
I wish to limit input within that column to a total of 70, preventing the user from assigning more than that.
What do I need to do?
Last edited by bmc2112; 03-14-2016 at 12:28 AM.
Change your Data validation to:
Allow: Custom
Source: =AND(B4>=0, B4<=70, SUM($B$4:$B$14)<=70)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ahh, yes, that's it. Thanks very much for the quick assist.
As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks