Hi

No, It doesn't. And the formula
=SUM(INDIRECT("MyRange"))
in worsheet cell returns an #REF error



--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Debra Dalgleish" wrote in message
...
Change the custom data validation formula to:

=SUM(INDIRECT("MyRange"))<=100

and it should work as expected.

Arvi Laanemets wrote:
Hi

Enter the same formula as used in data validation into adjacent column,
and
it works for all 4 examples exactly as needed.

But you are right - when I defined a named range as
=$A1
with cell A1 activated, then the custom validation formula
=AND(MyRange=0,MyRange<=100)
did work. I.e. named values are allowed, but any named ranges are
banned, or
what? Not very encouraging for my purpouses, as I want to restrict any
time
interval overlapings for item on given date in table (Date, Item, From,
To)
with variable number of rows. So using dynamic named ranges would be
preferable.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html