DCOUNT Help Needed

K

Khaledity

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
 
T

Teethless mama

D1: holds brand
E1: holds country of origin

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
Incorporating the User Profile location into a document template path 1
Identifying text in a string 4
I need a help formula 1
Dcount -Date Criteria - Won´t find it - 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Help required re Activation of Office 1
Need Help to Select certain Data from my spread sheet. 3

Top