Sumproduct with multiple date criteria

  • Thread starter Thread starter StonyfieldRob
  • Start date Start date
S

StonyfieldRob

Having a tough time with this one.

Sheet 1
Column A = Start Date, Column B = End Date, Column C = Quantity.

Sheet 2
Row A = Start Date, Row B = End Date.
I would like Row C to sum quantity from sheet 1 where ever the two date
ranges intersect.
The date ranges on sheet 2 represent the beginning and ending of a week
(Mon-Sun).

Sheet 1
Column A Column B Column C
01JAN2010 24JAN2010 1,000

Sheet 2
Row A 04JAN2010 11JAN2010 18JAN2010 25JAN2010
Row B 10JAN2010 17JAN2010 24JAN2010 31JAN2010
Row c 1,000 1,000 1,000 0
 
Do the Sheet 2 Start and End Dates both have to lie within the Sheet 1 Start
and End Dates?

Regards,

Tom
 
Back
Top