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

skaffapingvin

New Member
Joined
Apr 12, 2013
Messages
42
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.


2Q==



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.