Need help with this array formula please!!

[Jarodjp42]

Here is the data I am working with...


[TABLE="width: 545"]
<tbody>[TR]
[TD]MultiEmployees[/TD]
[TD]English (United States)-> Polish (Poland)[/TD]
[/TR]
[TR]
[TD]Afaf Steiert (Afaf Translations)[/TD]
[TD]Chinese (China)-> English (United States)[/TD]
[/TR]
[TR]
[TD][SN0017] Future Trans[/TD]
[TD]English (United States)-> Slovene (Slovenia)[/TD]
[/TR]
[TR]
[TD][SN0017] ES Localization & Translation[/TD]
[TD]English (United States)-> Finnish (Finland)[/TD]
[/TR]
[TR]
[TD]MultiEmployees[/TD]
[TD]English (United States)-> Chinese (China)[/TD]
[/TR]
[TR]
[TD]Afaf Steiert (Afaf Translations)[/TD]
[TD]English (United States)-> Thai (Thailand)[/TD]
[/TR]
[TR]
[TD]MultiEmployees[/TD]
[TD]Swedish (Sweden)-> English (United States)[/TD]
[/TR]
[TR]
[TD]MultiEmployees[/TD]
[TD]Arabic (Saudi Arabia)-> English (United States)[/TD]
[/TR]
[TR]
[TD][SN0017] Future Trans[/TD]
[TD]English (United States)-> Dutch (Belgium)[/TD]
[/TR]
[TR]
[TD][SN0017] ES Localization & Translation[/TD]
[TD]English (United States)-> Spanish (Spain)[/TD]
[/TR]
[TR]
[TD]Afaf Steiert (Afaf Translations)[/TD]
[TD]Chinese (China)-> English (United States)[/TD]
[/TR]
[TR]
[TD]Afaf Steiert[/TD]
[TD]English (United States)-> Slovene (Slovenia)[/TD]
[/TR]
</tbody>[/TABLE]

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!