I have the following formula:
={IF($F$9:$F$25="STEER",SUMIF($C$9:$C$25,"*TONGUE*",$D$9:$D$25),0)}
Unfortunately, the formula only runs the second part of the formula (the SUMIF part). It is essentially picking up all cells that have TONGUE in them and disregarding what variable is in Column...