Need help with this array formula please!!

[Jarodjp42]

Here is the data I am working with...

MultiEmployees	English (United States)-> Polish (Poland)
Afaf Steiert (Afaf Translations)	Chinese (China)-> English (United States)
[SN0017] Future Trans	English (United States)-> Slovene (Slovenia)
[SN0017] ES Localization & Translation	English (United States)-> Finnish (Finland)
MultiEmployees	English (United States)-> Chinese (China)
Afaf Steiert (Afaf Translations)	English (United States)-> Thai (Thailand)
MultiEmployees	Swedish (Sweden)-> English (United States)
MultiEmployees	Arabic (Saudi Arabia)-> English (United States)
[SN0017] Future Trans	English (United States)-> Dutch (Belgium)
[SN0017] ES Localization & Translation	English (United States)-> Spanish (Spain)
Afaf Steiert (Afaf Translations)	Chinese (China)-> English (United States)
Afaf Steiert	English (United States)-> Slovene (Slovenia)

<tbody>
</tbody>

This is the array formula I am using:

{=SUMPRODUCT((('Vendor List'!$B$2:$B$7204='Avg Words Per Day'!Q14))/COUNTIFS('Vendor List'!$B$2:$B$7204,'Vendor List'!$B$2:$B$7204&"",'Vendor List'!$A$2:$A$7204,'Vendor List'!$A$2:$A$7204&""))}

'Avg Words Per Day'!Q14 references the language Arabic (Saudi Arabia)-> English (United States)

Question: I am trying to get the total number of unique vendors for a specific language. For example, I want to know the total number of unique vendors for the language Arabic (Saudi Arabia)-> English (United States). The above formula gives me that but I am now looking to filter out the vendors that have [SN0017] in their name.

Can someone please help me with this formula???

Thanks!