Thank you Luke, Bernard, Dave...the solutions are pretty interesting. I will
try them out!

"Dave Peterson" wrote:

If that sending file is closed, then =indirect() won't work. =indirect()
requires that the sending workbook be open.

If that's a problem, then Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm

That includes =indirect.ext() that may help you.

And to make matters worse, =sumif() in xl2003 and below won't work with
=indirect(). I don't know about xl2007 and I don't know about xl2007's
=sumifs().

But there are alternatives if it doesn't. You can use =sumproduct(). (But that
can't use entire columns until xl2007.)



Tigerxxx wrote:

Hello,

What formula can I use to make the file name variable?
Ex: If my formula reads as follows:
SUMIFS([200902_UPS.xls]UPS_CSV_EXPORT!$G:$G,[200902_UPS.xls]UPS_CSV_EXPORT!$F:$F,A117)
For the month of February, the file name is 200902_UPS.xls.
I want to make the 200902 portion variable by referencing to a cell which
provides the month number so that in March, the name would be 200903.

Thank you

--

Dave Peterson