Place Stored Path Into Formulla

[ken8795]

I have the formula below in multiple cells and would like to store th
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 locatio
and not have to adjust each cells formula in the event of a change.

=SUMPRODUCT(--('E:\[producer ytd.xls]produce
ytd'!$A$2:$A$25000=$A$2&$B5)*(--('E:\[producer ytd.xls]produce
ytd'!$M$2:$M$25000=E$2)*(--('E:\[producer ytd.xls]produce
ytd'!$J$2:$K$25000="C")*(--('E:\[producer ytd.xls]produce
ytd'!$W$2:$W$25000)))))

I have made multiple attempts at this task, but have yet been able t
get the proper syntax.

Any suggestions would be appreciate

 

[damorrison]

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