Count Cells with certain value but don't double count

[ahjussi]

Which formula can I use if I want to achieve the following:

Column A = Client
Column B = Country

There are more columns with dates and accounts receivable.

I want to know how many clients I have for each country, but I don't want it to count the same client multiple times, e.g. Client A from Canada bought 4 times this month so 4 entries in the sheet and Client B from Canada bought once this month so it should show 2 Clients from Canada.

[Shareez Saleem]

Sumproduct(1/countifs(b2:b8,b2:b8,c2:c8,c2:c8))

[ahjussi]

That doesn't work unfortunately, because the formula counts the same client 4 times. Should only be once.

It should be like this:

Date Client Country Amount
01/08/2019 Client A Canada $500,00
02/08/2019 Client B Canada $1.000,00
03/08/2019 Client C France $250,00
04/08/2019 Client D Italy $450,00
05/08/2019 Client C France $1.500,00
06/08/2019 Client A Canada $200,00
07/08/2019 Client D Italy $350,00
08/08/2019 Client A Canada $900,00
09/08/2019 Client A Canada $1.100,00
10/08/2019 Client D Italy $600,00

Country Number of Clients Result Should be
Canada 2
France 1
Italy 1

[Shareez Saleem]

=SUM(--(FREQUENCY(IF($C$2:$C$11=B14,MATCH($B$2:$B$11,$B$2:$B$11,0)),ROW($B$2:$B$11)-ROW($B$2)+1)>0))
Press Control Shift Enter. This is an array formula.

[ahjussi]

Awesome thanks that worked.

Could you help me with another issue?

Unfortunately I cannot attach any files, don't know why.

It's the same data, just with an added column with account managers, so the employee who takes care of which client.

And I want to know how many new clients we got by employee by month.

I used this one: =SUMPRODUCT((MONTH(Date Range)=1)*(Account Manager Range="Employee 1").

Problem I have again is that it counts the same client multiple times instead of once.