Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DEFINED NAMES AND FORMULAS
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defined Names in Formulas when copying Worksheets in a Workbook | Excel Discussion (Misc queries) | |||
Defined Range Names in formulas | Excel Discussion (Misc queries) | |||
Defined names | Excel Discussion (Misc queries) | |||
Defined Names | Excel Programming | |||
hiding formulas and defined names in a worksheet | Excel Programming |