Summing data from multiple woorkbooks
 

I want to sum data from the same cell in multiple workbooks into another onto
a worksheet in another workbook. This may be an easy task, but I haven't
found a solution. Thanks.

Summing data from multiple woorkbooks
 

If there are only a couple of files involved and the paths are reasonable
try something like this:

=SUM('C:\TV\[File1.xls]Sheet1'!$A$1,'C:\TV\[File2.xls]Sheet1'!$A$1)

If there are many files involved it may be easier to just link to those
files and then use the linked range in the sum. For example:

A1: ='C:\TV\[File1.xls]Sheet1'!$A$1
A2: ='C:\TV\[File2.xls]Sheet1'!$A$1
A3: ='C:\TV\[File3.xls]Sheet1'!$A$1
etc
etc

Then: =SUM(A1:An)


--
Biff
Microsoft Excel MVP


"TDMSU84" wrote in message
...
I want to sum data from the same cell in multiple workbooks into another
onto
a worksheet in another workbook. This may be an easy task, but I haven't
found a solution. Thanks.