Formula Issue of counting texts that contains more than one in one column

I'm having issues with this formula, "=COUNTIF(CONTAINS({Tracking Sheet Range 1}, "Motorola", ({Tracking Sheet Range 3}, "In Progress")))" The term, 'Motorola' is in multiple cells in the same column and is used as a multiple dropdown menu option. Can someone please help?

Best Answer