| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DCount help | Excel Worksheet Functions | |||
| DCOUNT with different files | Excel Worksheet Functions | |||
| if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! | Excel Worksheet Functions | |||
| dcount with vba | Excel Worksheet Functions | |||
| dcount vba | Excel Worksheet Functions | |||
Linear Mode
