DEFINED NAMES AND FORMULAS
Yes - a defined name can be used to replace the referred to range in any
formula where the referred to range would be legitimate
if i have a defined name MyName with refers to A1,
=sumif(B:B,MyName,C:C)
and
=sumif(B:B,A1,C:C)
should return the same result.
--
Regards,
Tom Ogilvy
"Sean" wrote:
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
|