ExcelBanter - DCOUNT Help Needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - DCOUNT Help Needed (https://www.excelbanter.com/excel-worksheet-functions/146034-dcount-help-needed.html)

Khaledity

DCOUNT Help Needed

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

DCOUNT Help Needed

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

All times are GMT +1. The time now is 08:42 AM.