Select A1 & A2 and use this Validation scheme:

Allow: Custom
Formua: =$A$3<=100


In article ,
nc wrote:

My requirement is to have the function =SUM(A1:A2) in cell say A3 and this
cell cannot be greater than 100. I would prefer to use the data validation
method if possible.