1-

=SUM('[Reference Other Excel Files from Formulas and Functions 2.xlsx]Sheet1'!$B$3:$B$6)

2-

=SUM('D:\Excel Related\Tutorials\Tutorial Content - General\[Reference Other Excel Files from Formulas and Functions 2.xlsx]Sheet1'!B3:B6)

مثال:

=SUM('C:\Users\NameUser\Documents\[Book10.xlsx]Sheet1'!$A$1:$A$1)

=SUM('C:\Users\NameUser\Documents\[Book10.xlsx]Sheet2'!$A$1:$A$1)

=SUM('C:\Users\NameUser\Documents\[Book10.xlsx]Sheet3'!$A$1:$A$1)

منبع:https://www.teachexcel.com/excel-tutorial/reference-other-excel-files-with-formulas-and-functions_1401.html