D1: holds brand
E1: holds country of origin

=SUMPRODUCT(--(BrandList=d1),--(Country=E1))

"Khaledity" wrote:

Hi Folks,

I Need your help in the following:

Column A has "Brands' List", Column B has "Products' List" for each
brand, and Column C has "Country of Origin" for each Brand.

I need to count how many brand in each country of origin!

Thanks in advance.

Khaledity