Cell M11 formula , Drag right
Formula: copy to clipboard
=SUMPRODUCT(($E$7:$E$9=$L$4:$L$6)*(M$4:M$6>=$G$7:$G$9)*(M$4:M$6<=$H$7:$H$9)*$F$7:$F$9)