Count If formula

Question

I need to count how many affiliates each company has. However, there are numerous affiliate names and companies, so I am getting confused which formula would count the affiliates per company, when the names vary? I have copied an example below

Answer 1

It sounds like you're trying to get a unique count of the affiliates for each company. One option is to use dynamic array formulas.

For example, =UNIQUE(Table1[Company]) will return a unique list of companies. In my case, I entered this into column D.

Then I used the following formula in column E:

=COUNTA(UNIQUE(FILTER(Table1[Affiliate],Table1[Company]=D1)))