If 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

 

[RonB1111]

You're attachment did not come thru.

Look into the SUMIFS formula (if you have Excel 2007 or higher). If you need help, either post a small sample of your data here, or upload the excel file to a file sharing service and post the link to open it here.

Here's a link explaining SUMIFS: Use SUMIFS() to sum by multiple conditions in Excel | TechRepublic