Summing up the values from different sheet

[tta013]

Hi all,

Hope you are all well.

I have two sheets on my workbook and I need to sum up the values from Sheet one and display it in sheet two. And I am struggling....

On Sheet on, I have the following columns:

Product Date_Bought Qty
ABC 01/01/2011 3
ABC 03/01/2011 3
DEF 01/01/2011 3
ABC 08/01/2011 3
DEF 10/01/2011 3
---

On the Sheet two, I have the following columns and a row(Product)

Date
01/01/2011 07/01/2011 14/01/2011
ABC 6 3 0
DEF 3 3 0
----------------------------------------------------

As above what I would like to achieve is Total number of Qty for each product between the date rage (From 01/01/2011 - 06/01/2011, 07/01/2011 - 13/01/2011, etc...)

I am keen to find out how I can go about to achieve this and what would be the most efficient way to do this please?

Many thanks

---

 

[Robert Mika]

Formula in B2 copy down and accross:
=SUMPRODUCT(--(Sheet1!$A$2:$A$6=$A2),--(Sheet1!$B$2:$B$6>=B$1),--(Sheet1!$B$2:$B$6<?XML:NAMESPACE PREFIX = C$1)*(Sheet1!$C$2 /><C$1)*(Sheet1!$C$2:$C$6))< p></C$1)*(Sheet1!$C$2:$C$6))<>

 

[tta013]

Brilliant!
thank you!