Need help with a formula

Hi, I thought Id give this a shot as I've been struggling to get the correct formula.
I have two worksheets. examples below
The first work sheet contains the raw date of goods sold to a supplier
Column C - the date - 04/07/12
Column E - the product code - BES03
Column F - Quantity - 178

The second work sheet is where I need to populate the information
Column A - Product Code - BES03
Cell D1 - Date from - 15/02/2012
Cell E1 - Date to - 29/2/212
Column D & E (from row 2 is merged)

What I'm needing is if product code (Column A) falls between D1 E1 then populate with the quantity (column D & E) using the raw data rom the first worksheet

Hope that makes sense

Try:

=SUMIFS('Sheet1'!F:F,'Sheet1'!E:E,A2,'Sheet1'!C:C,">="&$D$1,'Sheet1'!C:C,"<="&$E$1)

Where Sheet1 is name of the raw data sheet (change as necessary).

NBVC said:

Try:

=SUMIFS('Sheet1'!F:F,'Sheet1'!E:E,A2,'Sheet1'!C:C,">="&$D$1,'Sheet1'!C:C,"<="&$E$1)

Where Sheet1 is name of the raw data sheet (change as necessary).

Click to expand...

Thanks this worked a treat