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 |
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 |
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 |
All times are GMT +1. The time now is 05:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com