Please remember that SUMPRODUCT has different syntax from SUMIF.


I think the formula should be something like:

SUMPRODUCT(([Testcase_No_2PW_Protect.xlsm]Sheet1!$A:$A =$B12)*([Testcase_No_2PW_Protect.xlsm]Sheet1!$E:$E))+SUMPRODUCT(([Testcase_No_3PW_Protect.xlsm]Sheet1!$A:$A=$B12)*([Testcase_No_3PW_Protect.xlsm]Sheet1!$E:$E))

You should use only the required range in the formulas (for example A5:A1000, E5:E1000) instead of full column references (A:A, E:E).