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
Teethless mama - 11 Jun 2007 16:04 GMT
D1: holds brand
E1: holds country of origin
=SUMPRODUCT(--(BrandList=d1),--(Country=E1))
> Hi Folks,
>
[quoted text clipped - 8 lines]
>
> Khaledity