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.

Validation
 

Hi,

Yes with Data Validation
Allow Custom
Formula =SUM($A$1:$F$7)=1

HTH
Carim

Validation
 

Thank you very much.

"Carim" wrote:

Hi,

Yes with Data Validation
Allow Custom
Formula =SUM($A$1:$F$7)=1

HTH
Carim