Hello BigD,
Try this
=SUMPRODUCT(NonSP45Delays[Total Hrs. Delayed],(NonSP45Delays[Craft]=$D39)*(TEXT(NonSP45Delays[Date],"yymm")=TEXT(E$38,"yymm")))
Based on file, assuming you are using Excel 2007 or later. SO you can use SUMIFS, which is more faster than SUMPRODUCT.
=SUMIFS(NonSP45Delays[Total Hrs. Delayed],NonSP45Delays[Craft],$D39,NonSP45Delays[Date],">="&EOMONTH(E$38,-1)+1,NonSP45Delays[Date],"<="&EOMONTH(E$38,0))
Copy to E39, then copy to E50. Then copy E39:E50 and paste to other blocks. DO NOT drag across, as this will change Table reference.