ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Summing cells from another workbook (https://www.excelbanter.com/excel-worksheet-functions/76365-summing-cells-another-workbook.html)

smashleywhite

Summing cells from another workbook
 
How can I create a formula that gives me the sum of cells that are located in
an entirely different workbook? Is this even possible?

Bob Phillips

Summing cells from another workbook
 
Just use SUM, like this

=SUM('C:\Documents and Settings\Bob\My Documents\My Spreadsheets\[Toolkit
Index.xls]Sheet1'!$F$1:$F$4)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"smashleywhite" wrote in message
...
How can I create a formula that gives me the sum of cells that are located

in
an entirely different workbook? Is this even possible?





All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com