| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
External reference to a Column
Hi,
I have the following formula in wb1 that only works when referenced wb is opened: SUMPRODUCT(--(MONTH('[P&L Fixed Income_20090414.xls]Histórico Productos'!$A$7:$A$160)=MONTH(today)),OFFSET('[P&L Fixed Income_20090414.xls]Histórico Productos'!$A$7:$A$160,0,M27-1)/1000) The thing is that I want it to work when the referenced workbook is closed. Is there an alternative solution to get the same result? Many Thanks in Advance!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| external Excel Add-In reference | Excel Worksheet Functions | |||
| External Reference in Vlookup | Excel Discussion (Misc queries) | |||
| External Reference | Excel Discussion (Misc queries) | |||
| External reference as a condition | Excel Worksheet Functions | |||
| External reference as a condition | Excel Worksheet Functions | |||
Hybrid Mode
