If the cells are in the same spot in each workbook (add cell a1 from all
sheets) you could do
=SUM('[Book1]Sheet1:Sheet3'!A5)+SUM('[Book3]Sheet1:Sheet3'!$A$6)

Note that it helps to have both workbooks open when you input formula.
Otherwise you'll have to enter the complete file extension into the formula.

--
Best Regards,

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


"Bev" wrote:

Good point! I'm adding multiple sheets in one workbook to multiple sheets in
another workbook.

"Luke M" wrote:

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?