Can I pull sum from one workbook into another?

[Bernadette]

Can I pull sum from one workbook into another?

 

[Sean Timmons]

Yes. More details, perhaps?

 

[Jacob Skaria]

=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)

If this post helps click Yes

 

[David Biddulph]

Yes

 

[David Biddulph]

If you want to know HOW, click in your destination cell, type the = sign, go
to your source sheet, click in the source cell.
The formula will show something like =[Book1]Sheet4!$A$1
Enter to accept that formula.

 

[Bernadette]

I have two seperate spreadsheets. Spreadsheet A has a summary page that I
would like to have include a total that is located on spreadsheet B. Can it
be done and do you know how to do that?

 

[Bernadette]

I tried that, but it doesn't work. If I want to link information on a
different tab in the same workbook it works, but not on a different workbook.
Any ideas?

=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)

If this post helps click Yes
---------------
Jacob Skaria

Can I pull sum from one workbook into another?

 

[Sean Timmons]

Did you include the ' and the [ as needed? It would be best to type =SUM(
then highlight the desired range of cells to sum.

I tried that, but it doesn't work. If I want to link information on a
different tab in the same workbook it works, but not on a different workbook.
Any ideas?

=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)

If this post helps click Yes
---------------
Jacob Skaria

Can I pull sum from one workbook into another?

 

[Gord Dibben]

It would not work if you have your two workbooks open in separate instances
of Excel.

Close one instance and open both workbooks in a single instance of Excel.


Gord Dibben MS Excel MVP

I tried that, but it doesn't work. If I want to link information on a
different tab in the same workbook it works, but not on a different workbook.
Any ideas?

=SUM('[Workbook.xls]Sheetname'!$C$2:$C$6)

If this post helps click Yes
---------------
Jacob Skaria

Can I pull sum from one workbook into another?