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