This is the formula I am using:
=IF(SUMPRODUCT(COUNTIF(C4:C8,{"Left Square Arm Combo";"Right Square Arm Combo";"2 Square Arm Combo";"2 Arm Left Radius Combo";"2 Arm Right Radius Combo";"10.5 Armed Right Radius";"10.5 Armed Left Radius";"9.5 Armed Right Radius";"9.5 Armed Left...