Sum across workbooks, same cell, same tab name

[zakasnak]

I know I can use an indirect formula to sum across sheets in the same workbook, but is there a way to sum across workbooks, using the same tab name and same cell?

 

[kaos_king]

Yes I believe you can, place the workbook name's in square brackets before the sheet name, like so:

=SUM([Book1]Sheet1!$A$1, [Book2]Sheet1!$A$1)