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?