Can you replace '[dailyinput.xls]' with A1 (cell reference) and then change
the value in A1 when needed?

Ryan---

--
RyGuy


"Mike H." wrote:

In the formula at the bottom, is there a way to "variabilize" the file name
and path so that based on the value of cell the path might be
n:\accounting\income audit\automation\lastmonth\[dailyinput.xls]

or perhaps the filename would be different:

n:\accounting\income audit\automation\[dailyinputDec.xls]


=SUMPRODUCT(('N:\Accounting\Income
Audit\Automation\[DailyInput.xls]InfoGenesis'!$C$10:$C$575=$A7)*('N:\Accounting\Inc ome
Audit\Automation\[DailyInput.xls]InfoGenesis'!$B$10:$B$575=$B7)*('N:\Accounting\Inc ome Audit\Automation\[DailyInput.xls]InfoGenesis'!D$10:D$575))