用于计算每个销售员的唯一客户数的Excel公式是什么?

问题描述：

请参见下图.我使用以下公式对表的总行中的唯一客户数进行计数:

See image below. I use the following formula to count the number of unique customers on the total row of the table:

=SUMPRODUCT( -- (FREQUENCY(MATCH(C14:C20,C14:C20,0),ROW(C14:C20)-ROW(C14)+1)>0))

但是我需要一个略有不同的公式，以便在表格外的摘要"部分中按销售员计算唯一客户.

But I need a slightly different formula to count unique customers by salesperson for my summary section outside of the table.

答

在C8中尝试一下，

=SUMPRODUCT((B$14:B$20=$B8)/(COUNTIFS(C$14:C$20, C$14:C$20, B$14:B$20, $B8)+(B$14:B$20<>$B8)))

填写.