Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation
Can I set a validation for a range of cells so that the sum of the range must
always equal a certain value? For example, if I attempt to change one of the values in cells a1:f1 I would like the user to be given a message that the sum of the range must be equal to "1" and so they are aware that another change in the range must be made to either increase or decrease other values so that the sum is not affected. Thank you in advance for your assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation
Hi,
Yes with Data Validation Allow Custom Formula =SUM($A$1:$F$7)=1 HTH Carim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation
Thank you very much.
"Carim" wrote: Hi, Yes with Data Validation Allow Custom Formula =SUM($A$1:$F$7)=1 HTH Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with hyperlinks | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data Validation Window? | Excel Discussion (Misc queries) |