不重複三格計數 (14450)

F4{=SUM(IFERROR((B$3:B$22=E4)/COUNTIFS(A:A,">="&F$1,A:A,"<="&F$2,B:B,E4,C:C,C$3:C$22),))

另解{=COUNT(0/(MATCH(1&C$3:C$22,(A$3:A$22>=F$1)*(A$3:A$22<=F$2)*(B$3:B$22=E4)&C$3:C$22,)=ROW($1:$20)))