Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Place Stored Path Into Formulla
I have the formula below in multiple cells and would like to store the path for the external files in a Cell on Sheet 2 of the same Workbook. This would allow me to make any necessary Path changes in one location and not have to adjust each cells formula in the event of a change. =SUMPRODUCT(--('E:\[producer ytd.xls]producer ytd'!$A$2:$A$25000=$A$2&$B5)*(--('E:\[producer ytd.xls]producer ytd'!$M$2:$M$25000=E$2)*(--('E:\[producer ytd.xls]producer ytd'!$J$2:$K$25000="C")*(--('E:\[producer ytd.xls]producer ytd'!$W$2:$W$25000))))) I have made multiple attempts at this task, but have yet been able to get the proper syntax. Any suggestions would be appreciated -- ken8795 ------------------------------------------------------------------------ ken8795's Profile: http://www.excelforum.com/member.php...o&userid=36411 View this thread: http://www.excelforum.com/showthread...hreadid=564033 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Relative path for XML data file? | Charts and Charting in Excel | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Link a cell to another workbook with a different path | Excel Worksheet Functions | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) |