Thread: [Solved] Problems with linking to other spreadsheets
View Single Post
 
Old 02-03-2016, 10:37 PM
xor xor is offline Windows 10 Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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).
Reply With Quote