Use the custom formula: =$A$4=0


Danny wrote:
On Aug 19, 11:14 am, Debra Dalgleish
wrote:

You're welcome, and thanks for describing how you got it to work.
In my instructions, there's an error in the formula, which should be:
=$A$4=6
so it refers to the cell with the total.





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?

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

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

- Show quoted text -


Well I was wrong because if the person enters a negative amount in say
a1 the total is negative and it won't allow me to continue entering
because the validation rule kicks in due to the total being less than
zero. Any Ideas?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html