| 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, |
| 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) | |||
Threaded Mode
