Counting Repeat Values in One Cell with IF function

[ProfessionalAmateur]

Thanks in advance for any help

I have columns with drop down lists. Column F has a dropdown list of radio types (Ubi AC Lite, Ubi Prism Gen 2, etc). There is also a Column K that has a drop down list designating whether the radio was installed or picked up (Install, Pickup, Upgrade). I need to count how many Ubi AC Lites are installed and have tried multiple variations of COUNTIFS and SUMPRODUCT to no avail. I can only get a returned value of 1 even if Ubi AC Lite is listed multiple times in the same cell.

current formula I am using is =SUMPRODUCT((LEN(F11:F135)-LEN(SUBSTITUTE(F11:F135,T12,""))) /LEN(T12)) with T12 containing Ubi AC Lite in it. This returns the values for every instance of Ubi AC Lite listed but I cannot add the IF function or condition of only counting if "Install" is selected in Column K. Is there a way to add an IF or condition to the current formula I have?

Riverside.xlsm
	F	G	H	I	J	K
10	Radio Customer	Antenna Customer	CPE	Misc	Speed/Voice	Install/Upgrade/Pickup/TruckRoll
11	Ubi AC Lite, Ubi AC Lite, Ubi AC Lite	Ubi RD5G30, Ubi RD5G30				Install
12	Ubi Prism Gen 2, Ubi LTU LR					Upgrade
13	Ubi AC Lite					Install
December 2022

Cells with Data Validation
Cell	Allow	Criteria
F11:F144	List	=$T$11:$T$55
G11:G451	List	=$X$11:$X$33
H11:H308	List	=$AB$11:$AB$23
I11:I256	List	=$AF$11:$AF$20
K11:K13	List	=$AG$81:$AG$84

 

[Z51]

Does this work?

=SUMPRODUCT(((LEN(F11:F135)-LEN(SUBSTITUTE(F11:F135,$T$12,"")))/LEN($T$12))*(K11:K135="Install"))

 

[ProfessionalAmateur]

Does this work?

=SUMPRODUCT(((LEN(F11:F135)-LEN(SUBSTITUTE(F11:F135,$T$12,"")))/LEN($T$12))*(K11:K135="Install"))

Worked perfectly! Thanks!