in the open workbook add

=SUM('C:\MyDir\[2005 Expenses.xls]MVP Expenses'!A3:A5)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MVP Contracting" <MVP wrote in
message ...
I am trying to transfer a sum of 3 data values from a closed spreadsheet
(2005 Expenses), from a specific worksheet within that spreadsheet (MVP
Expenses) to another opened worksheet (Overhead) within a different
spreadsheet (Payroll Expenses). Is this possible?

I can't find a formula for this anywhere.

Please let me know,

Thanks, MV )