# Thread: Need help with a formula

1. ## 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

2. 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).

3. Originally Posted by NBVC
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).
Thanks this worked a treat

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•