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