Summing data from multiple woorkbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top