Hi all,

I have a problem I was hoping someone could help me with. What I'm doing is
using a =sumif() to pull some numbers from different files. On the files
that I'm pulling the information from I have two ranges named Code and
Current and we'll call the actual file names Table.xls, Table1.xls,
Table2.xls, etc. On the file that I'm trying to pull the information into I
have =sumif('Table.xls'!Code,A5,'Table.xls'!Current) in C5.
This pulls the information fine but I have 300 rows I have this formula in.
I want to be able to just put the file name like Table.xls in C4 and have it
update all the rows without having to change the formula and copy it down
each time I change the file name. That way I could just change the file name
from Table.xls to Table1.xls in C4 and have everything update automatically.
I tried =sumif($C$4!Code,A5,$C$4!Current) but that wasn't working work. Does
anybody know of a way to do this? Thanks for any help you can offer.

ww