=SUMPRODUCT(((Active!$G$2:$G$426>=6)*(Active!$G$2:$G$426<=10))--(Active!$A$2:$A$426="*construction*"))

Thank you so much for your suggestion however it is not picking up the second half. I get the same count as if the filter by construction was not there.

s