SUMPRODUCT with "*" partial string lookup

Hi

I know I can use "*" with a SUMIF function to look at a partial string.

But I need to look up data on a separate workbook which needs to be kept closed (or rather, cannot be opened by all users due to restrictions).

So instead, I need to use SUMPRODUCT so the links will work when workbook 2 is closed.

But can I use the "*" partial string method with SUMPRODUCT? I can't seem to get it to work.



I'm using this:
=SUMPRODUCT('[source]Sheet1'!$A:$A=D5&"*")*('[Source]Sheet1'!$E:$E)

I'm looking at the partial string in cell D5

If that partial string in is column A in workbook2, collect the sum of column E in workbook2






Your help would be much appreciated.