=[Book3]Sheet1!$D$1+[Book4]Sheet1!$E$1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Shoobiloo" wrote in message
...
I have 3 workbooks. I want to add numbers from workbook 1 and workbook 2
into
a total in workbook 3. Is there a way to do this? If so, how?