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

you could name your formula, then you could just insert the named
formula in the cells...
goto, insert,name,write a name,in the reference box enter your formula

then in the cells with the formula, enter =formulaname

another quick way would be to highlite the ranges that require the
formula, then write the formula, then instead of pressing enter, hit
Ctrl Enter then all the cells highlited will have the formula