| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Name in cell ref used in a formula
Hello,
I have the following formula (this is only a part of the formula) : =SUMPRODUCT(--(MONTH('S:\BTeams\Affinity\Affinity\Automotive Ops Database\MTC Capture Tool 2\Fred''s Team\[MTC - Joe Bloggs.xls]Mid-Term'!$B$3:$B$503)=12) I have Joe Bloggs as a name in the formula and also in a cell. Can i use the cell referrence, such as C6 instead of the name? Would this then referrence the external spreadsheet correctly or am i stuck using the full name? So it would read [MTC Tool - "Cell Ref".xls] Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name in cell ref used in a formula
Would this then referrence the external spreadsheet correctly or am i stuck
using the full name? There is a way to do it the way you want with built-in functions *BUT* the referenced file *MUST* be open. This is usually a "deal breaker"! There are a couple of other methods that might work on the closed file but these require VBA routines and one is an add-in. Still interested? -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... Hello, I have the following formula (this is only a part of the formula) : =SUMPRODUCT(--(MONTH('S:\BTeams\Affinity\Affinity\Automotive Ops Database\MTC Capture Tool 2\Fred''s Team\[MTC - Joe Bloggs.xls]Mid-Term'!$B$3:$B$503)=12) I have Joe Bloggs as a name in the formula and also in a cell. Can i use the cell referrence, such as C6 instead of the name? Would this then referrence the external spreadsheet correctly or am i stuck using the full name? So it would read [MTC Tool - "Cell Ref".xls] Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name in cell ref used in a formula
As long as i can get Excel do what i want it do i'm interested!
thanks "T. Valko" wrote: Would this then referrence the external spreadsheet correctly or am i stuck using the full name? There is a way to do it the way you want with built-in functions *BUT* the referenced file *MUST* be open. This is usually a "deal breaker"! There are a couple of other methods that might work on the closed file but these require VBA routines and one is an add-in. Still interested? -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... Hello, I have the following formula (this is only a part of the formula) : =SUMPRODUCT(--(MONTH('S:\BTeams\Affinity\Affinity\Automotive Ops Database\MTC Capture Tool 2\Fred''s Team\[MTC - Joe Bloggs.xls]Mid-Term'!$B$3:$B$503)=12) I have Joe Bloggs as a name in the formula and also in a cell. Can i use the cell referrence, such as C6 instead of the name? Would this then referrence the external spreadsheet correctly or am i stuck using the full name? So it would read [MTC Tool - "Cell Ref".xls] Thanks, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name in cell ref used in a formula
There is an add-in available he
http://xcell05.free.fr/english/ Look for Morefunc.xll This has a function called INDIRECT.EXT that will do what you want. See the add-in help on its use. -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... As long as i can get Excel do what i want it do i'm interested! thanks "T. Valko" wrote: Would this then referrence the external spreadsheet correctly or am i stuck using the full name? There is a way to do it the way you want with built-in functions *BUT* the referenced file *MUST* be open. This is usually a "deal breaker"! There are a couple of other methods that might work on the closed file but these require VBA routines and one is an add-in. Still interested? -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... Hello, I have the following formula (this is only a part of the formula) : =SUMPRODUCT(--(MONTH('S:\BTeams\Affinity\Affinity\Automotive Ops Database\MTC Capture Tool 2\Fred''s Team\[MTC - Joe Bloggs.xls]Mid-Term'!$B$3:$B$503)=12) I have Joe Bloggs as a name in the formula and also in a cell. Can i use the cell referrence, such as C6 instead of the name? Would this then referrence the external spreadsheet correctly or am i stuck using the full name? So it would read [MTC Tool - "Cell Ref".xls] Thanks, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name in cell ref used in a formula
Thanks for the reply, there are some interesting functions in that add-in!
"T. Valko" wrote: There is an add-in available he http://xcell05.free.fr/english/ Look for Morefunc.xll This has a function called INDIRECT.EXT that will do what you want. See the add-in help on its use. -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... As long as i can get Excel do what i want it do i'm interested! thanks "T. Valko" wrote: Would this then referrence the external spreadsheet correctly or am i stuck using the full name? There is a way to do it the way you want with built-in functions *BUT* the referenced file *MUST* be open. This is usually a "deal breaker"! There are a couple of other methods that might work on the closed file but these require VBA routines and one is an add-in. Still interested? -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... Hello, I have the following formula (this is only a part of the formula) : =SUMPRODUCT(--(MONTH('S:\BTeams\Affinity\Affinity\Automotive Ops Database\MTC Capture Tool 2\Fred''s Team\[MTC - Joe Bloggs.xls]Mid-Term'!$B$3:$B$503)=12) I have Joe Bloggs as a name in the formula and also in a cell. Can i use the cell referrence, such as C6 instead of the name? Would this then referrence the external spreadsheet correctly or am i stuck using the full name? So it would read [MTC Tool - "Cell Ref".xls] Thanks, |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name in cell ref used in a formula
Yeah, it's probably one of the most popular/useful add-ins out there.
Thanks for the feedback! -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... Thanks for the reply, there are some interesting functions in that add-in! "T. Valko" wrote: There is an add-in available he http://xcell05.free.fr/english/ Look for Morefunc.xll This has a function called INDIRECT.EXT that will do what you want. See the add-in help on its use. -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... As long as i can get Excel do what i want it do i'm interested! thanks "T. Valko" wrote: Would this then referrence the external spreadsheet correctly or am i stuck using the full name? There is a way to do it the way you want with built-in functions *BUT* the referenced file *MUST* be open. This is usually a "deal breaker"! There are a couple of other methods that might work on the closed file but these require VBA routines and one is an add-in. Still interested? -- Biff Microsoft Excel MVP "Phendrena" wrote in message ... Hello, I have the following formula (this is only a part of the formula) : =SUMPRODUCT(--(MONTH('S:\BTeams\Affinity\Affinity\Automotive Ops Database\MTC Capture Tool 2\Fred''s Team\[MTC - Joe Bloggs.xls]Mid-Term'!$B$3:$B$503)=12) I have Joe Bloggs as a name in the formula and also in a cell. Can i use the cell referrence, such as C6 instead of the name? Would this then referrence the external spreadsheet correctly or am i stuck using the full name? So it would read [MTC Tool - "Cell Ref".xls] Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Hybrid Mode
