close

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?

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)

quot;smashleywhitequot; gt; wrote in message
...
gt; How can I create a formula that gives me the sum of cells that are located
in
gt; an entirely different workbook? Is this even possible?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()