Count Unique Names in list w/ Additional Criteria?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been able to use the formula below to count the "unique" company names
in list, but also wanted to use additional criteria such as Unique company
names where state = TX (separate column).... what would the syntax be? is
this possible?.

=SUMPRODUCT(1/(COUNTIF(Company_Name,Company_Name)+(Company_Name="")))
 

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

Count unique with multiple criteria 3
Retrieve unique items with 2 criteria (USING SUMPRODUCT) 5
Count Unique Values 4
FREQUENCY with multiple criteria 6
Access Dcount (multiple criteria) 3
Unique sumproduct with criteria! 5
count unique values in one column for a set value in another col. 2
Count Unique Numbers if Names Match 4

Back
Top