Summing same sheet $A$1 in multiple workbooks

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

Guest

H E L P ....

I have 26 different files that each have a 9 sheet workbook. I need to "summarize" all of the files (workbooks) into a consolidated workbook with the 9 worksheets. I know if you wanted to sum $A$1 in all of the worksheets, I can place all of the worksheets between two blank worksheets called A and one called Z and write the cell to sum(A:Z!$A$1)

Is it possible to do the same with files???????

Thank

Jerry
 
Dear Jerry

It is possible to reference external workbooks in your
formula

Using a sum function as an example your formula would look
something like this...

=SUM(NetworkDrive:\DrivePathway\[Workbook.xls]Sheet1'!
$A$4:$A$15)

Hope that this helps

Paul
-----Original Message-----
H E L P .....

I have 26 different files that each have a 9 sheet
Click to expand...
workbook. I need to "summarize" all of the files
(workbooks) into a consolidated workbook with the 9
worksheets. I know if you wanted to sum $A$1 in all of
the worksheets, I can place all of the worksheets between
two blank worksheets called A and one called Z and write
the cell to sum(A:Z!$A$1).
 
Paul, I'm with you on that ... but it there any may to group the workbooks so I do not have to list each one as in the from:to!$a$1 sheet naming here?
 
Back
Top