I didn't realize there would be other text other than just New in the second range. Putting * between the quotes does not create wildcards so that's why you were getting 0 - it was looking for the exact text *New*. The formula below works around this. I don't know what other text could be in this column, but note that words containing 'New' will also return a positive. Perhaps unlikely, but something like Newton would return a positive. Let me know if you need anything else.

=SUMPRODUCT((TEXT($E$7:$E$100,"MMM")=ExecSumm!H7)*(1-ISERROR(FIND("New",$F$7:$F$100))))