Try this regular formula

=SUMPRODUCT((A1:C1)*TRIM(SUBSTITUTE(A2:C2,"Hotdogs","")))
Adjuts ranges accordingly