SUMIF With "Indirect" link to closed workbook

[rehanahmad]

Hello all
I want to use a combination of Sumif and Indirect function to link to data in closed workbook in a folder location. I have wrote =SUMIF(INDIRECT("'["&Sheet2!C9&".xlsx"&"]"&Sheet2!D9&"'!"&"T:T"),BB14,INDIRECT("'["&Sheet2!C9&".xlsx"&"]"&Sheet2!D9&"'!"&"H:H")), where Sheet2!C9 and Sheet2!D9 are cells reference to file locations and sheet name respectively. The formula is giving "#REF!", can someone see what is wrong with the formula?

 

[rehanahmad]

Impressive typo given that you have correct closing parentheses at the end.

I am not giving the full formula as it might breach my work ethics thats why i copied and pasted the formula and changed some texts just to give an idea.

 

[RoryA]

Yes but you changed it to a completely different formula. That is not just a typo, especially as one formula would work with a closed workbook, and the other would not!