Try this

=SUMPRODUCT(--ISNUMBER(MATCH('INITIATING DEVICES'!B7:B2499,{"DUCT","duct detector","sup detector"},0)))