統計客户人數 依條件 (9416)

H2=SUMPRODUCT((MATCH(A$2:A$13&E$2:E$13&(C$2:C$13>12),A$2:A$13&E$2:E$13&(C$2:C$13>12),)=ROW($1:$12))*(E$2:E$13=G2)*(C$2:C$13>12))

另解=COUNT(0/FREQUENCY(ROW($1:$13),MATCH(A$2:A$13,A$2:A$13,)*(E$2:E$13=G2)*(C$2:C$13>12)))-1