Summing cells from another workbook

S

smashleywhite

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?
 
B

Bob Phillips

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)
 
Top