=SUMPRODUCT(('November Consolidation'!$B$9:$B$487=A38)*(ISNUMBER(SEARCH("No^^",'November Consolidation'!$F$9:$F$487&"^^"))))