Sum of the file in the folder

[sur]

Hello Team,

i have all the files names(.xlsx) that is in the folder and currently i have to sum Column B from "sheet1" of each cell.


NOTE: All the file will be closed, except the master with all the xlsx file names in the folder & in the same sheet i have the formula.

 

[James006]

Hello,

In order to get values from closed files ...

see link : https://exceloffthegrid.com/getting-values-from-a-closed-excel-workbook/

Hope this will help