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= "")))