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="")))
 
You could use the FREQUENCY method to count unique items
based on 1 or more criteria. George Simms posted a simple
example a long time ago:

http://tinyurl.com/3pkqr

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

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
Count Unique with Multiple Criteria 3
Access Dcount (multiple criteria) 3
Count Unique Numbers if Names Match 4
Unique sumproduct with criteria! 5

Back
Top