If three criterias are met summarize value to a cell on another workbook/sheet

[skaffapingvin]

Hi,

I'm in desperate help. I have been thinking about possible solution to this using VLOOKUP but so far no luck.
Here is the situation I have to different workbooks.

Workbook no.1 with one sheet(sheet 1).
Workbook no.2 with 12 different sheets, one sheet per month.

This is workbook 1/Sheet 1.
I want to see the daily invoice sum of the suppliers "OHO" and "TakaBu" per day, in column L and M.

This is workbook 2/September sheet
I want the all invoice sums from the suppliers "OHO" and "TakaBu" to be summarized per day on work sheet 1, but only invoices that are marked Legal unit: "CEN 3940" are to be taken into consideration.


Can anyone help me with this? I appreciate all help I can get. Because I have searched but I couldn't find a solution to this.

Regards, Eric

 

[etaf]

the image has not worked

you could probably use a pivot table to do this very easily