From: StonyfieldRob on 27 May 2010 17:09 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 From: Tom-S on 27 May 2010 17:36 Do both the Start Date and End Date on Sheet 2 need to lie within the Start Date and End Date of Sheet 1? Regards, Tom "StonyfieldRob" wrote: > 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 >