Can I pull sum from one workbook into another?

Yes. More details, perhaps?

"Bernadette" wrote:

Can I pull sum from one workbook into another?

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?

"Sean Timmons" wrote:

Yes. More details, perhaps?

"Bernadette" wrote:

Can I pull sum from one workbook into another?

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

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


"Bernadette" wrote:

Can I pull sum from one workbook into another?

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?

"Jacob Skaria" wrote:

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

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


"Bernadette" wrote:

Can I pull sum from one workbook into another?

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

"Bernadette" wrote:

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?

"Jacob Skaria" wrote:

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

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


"Bernadette" wrote:

Can I pull sum from one workbook into another?

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

On Wed, 21 Oct 2009 12:55:02 -0700, Bernadette
wrote:

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?

"Jacob Skaria" wrote:

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

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


"Bernadette" wrote:

Can I pull sum from one workbook into another?

Yes
--
David Biddulph


"Bernadette" wrote in message
...
Can I pull sum from one workbook into another?

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.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Yes
--
David Biddulph


"Bernadette" wrote in message
...
Can I pull sum from one workbook into another?