DEFINED NAMES AND FORMULAS
Yes, try it.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Sean" wrote in message
...
I have an area of time formats that I have defined a name to, I use this
for
cell validation, so they can only pick from the time I give. Can a
formula
read off of the defined name, such as SUMPRODUCT((A1:A100=DEFINED
NAME)*D1:D100)
Thanks,
Sean
|