DEFINED NAMES AND FORMULAS

[Sean]

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

[Bob Phillips]

Yes, try it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sean" <Sean@discussions.microsoft.com> wrote in message
news:7D195E09-EF49-4C82-A8A0-42C42F8D276C@microsoft.com...
> 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

[Tom Ogilvy]

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