On Aug 19, 11:03 am, Danny wrote:
On Aug 19, 9:33 am, Debra Dalgleish wrote:





Put the data validation on the cells where the values are entered. For
example, if the 1,2,3 are in cell A1:A3, and the total is in A4:

Select A1:A3
Choose DataValidation
For Allow, choose Custom
In the formula box enter: =$A$3=6
Click OK

Danny wrote:
I would like to know if it is possible to use data validation on a
field that is summing/totalling data. IE total 1+2+3=6. is it
possible in the total field to use data validation so if the total
is not equal to 6 then error?

I have tried this by establishing sum field totalling a1...a5 in A6
field, but when I go into input data into a1..a5 and it totals the
data validation on A6 doesn't provide an error message?

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html

Thanks for the help. Custom allows me to do the following =A1:A30 so
if the total in A4 is less than 0 then it works. Thanks for showing
me custom- Hide quoted text -

- Show quoted text -

Sorry I mispoke. So if I do custom and select A1:A3 when I place a
negative number into the field I get the validation error. What I
would like is if I put any values in A1:A3 it accepts those values.
What I want is the validation rule to come up if the total of A1:A3 is
less than 0

Is that possible?