Hey

I dont know how to attach the sheets with reply so am pasting the formula to be put in sheet 2 cell G2, and copy all the way below:

=SUMPRODUCT(('Sheet 1'!$B$2:$B$14='Sheet 2'!B2)*('Sheet 1'!$C$2:$C$14<'Sheet 2'!F2)*('Sheet 1'!$H$2:$H$14>'Sheet 2'!F2)*('Sheet 1'!$F$2:$F$14='Sheet 2'!C2)*('Sheet 1'!$G$2:$G$14="Sale")*('Sheet 1'!$A$2:$A$14))

Hope it helps!
#
cheers
BI.