Perhaps something like
='[Book1]Sheet1'!A1+'[Book2]Sheet2'!$A1

I wasn't sure from your post whther your adding multiples sheets in one
workbook and want the result in a 2nd workbook, or transferring data from one
workbook, or adding from 1 sheet from 2 different workbooks. Hopefully you'll
be able to modify the formula as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bev" wrote:

I am trying to add data from one workbook to data in another workbook. All
the data are in the same cells on different sheets in the two workbooks.
What is the syntax I need to accomplish this?