Excel formula error

[zmelkam]

Hello! All 

Just I am looking for support on the excel formula. I am working sum with multiple spreadsheets and unfortunately, the formula isn't working properly. What will be the problem and what shall I do? Thanks

[#2]

Please upload a sample workbook (Remove any personal or confidential information).