Help function sum product or similar

In the attached file I should find the result in D2-D3-D4 sheet1 corresponding to the columns C-E-G Sheet2.

Terms: search for article column B sheet1 with date in column A included in the date column of Sheet2 H-I
and column C sheet1 is less than or = column B-D-F Sheet2.
Thank you

@ Richard sheet1 in column C the value 3.72 is set manually to be compared with columns B-D-F Sheet2 and report the value C-E-G
- Cost B = 4.31 8 > = 3.72
- Cost D = 3,83 5 > = 3.72
- Cost F = 3,45 3 <= 3.72 ok 3

@bebo021999 if you can attach the file as the translation to me by mistake.

In the case where 2 samples meet the criteria do you choose the highest value (your last example has 5 or 10 as possible results)?

Ok John
In the case of the last example you take the first valid column D Sheet2
then value 10

I settled with "-" the error was not from this but somewhere # N / A.
Very very good at finding this formula compliments and many thanks.