You can't do it easily with a single formula unless you only have a few
files.
You can use a formula to each file and sheet and then add them up.
=[yourfile.xls]yourworksheet!$D$34
Or, use a macro to get the data from each file and sum it in the cell of
your choice.

--
Don Guillett
SalesAid Software

"Betsy" wrote in message
...
I have a bunch of invoices in a folder and need to get a total on how much
I
made. Can i set up a formula that will import cell d34 from every file in
the folder I specify and give me a total?