Summing data from multiple woorkbooks

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.
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining data from multiple workbooks 5
CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN 2
Excel Highlighting duplicates 0
Aggregating data among multiple workbooks 1
summing same cell in multiple worksheets 3
Compile data from several workbooks 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Summing multiple account #s in one cell, by referencing 4

Top