A little question!
How can I sum up the values in the same cell of the all excel files, those are located in the same folder?
Thanks for your guidance!!!
=SUM('C:[A.xlsx]Sheet1'!A1, 'C:[B.xlsx]Sheet1'!A1. 'C:[C.xlsx]Sheet1'!A1, ...)
There are 35 files so I don't want to repeat it several times...
Also, Is there a way to prevent the cell from writing #REF and calculate missing cells (If the related excel file is missing) as Zero?
For example If I dont have the C.xlsx file, I want the cell to think of
in the formula. So there wont be #REF problem anymore...
I appreciate any other alternative routes too!!!
Thanks so much!