SUMIF Matrix formula -> get data from external (closed) data sheet

Hi all,

I really hope someone can help, I have the following problem:

I have two seperate files, and I would like to insert the data from one (keymetrics_201604.xlsx) into the other (roi_overview.xlsx).
Doing this by sumif formula both files need to be opened, that's why I have tried to create a matrix-formula using sum & if function but this doesn't work.

My formula looks like this:
{=SUMME(WENN([keymetrics_201604.xlsx]Dataset1!$B:$B="*Carin*";[keymetrics_201604.xlsx]Dataset1!$C:$C))}
the result shown = 0

but this isn't right. When I use a normal sumif formular, I get the right results.

Is the matrix formula I use wrong? Is there a mistake?
Or is there any other way to get the data I wan't -> fe VBA to insert the according data?

Thank you for your support.

Best wishes
Martina

Hi,

thanky for your fast response.

* are used as wildcards, I am not quite sure how to change the formula to sumproduct-formula to get the result that I would get using sumif...
could you probably help me here?