Maybe

=SUMPRODUCT( (Data!$A$2:$A$1376 = 'Monthly Summary'!$A5) * (LEFT(Data!$B$2:$B$1376, 2) = 'Monthly Summary'!$F$2) * Data!$D$2:$D$1376)