計數 三項不重複 (9145)


J2{=COUNT(0/(MATCH(A$2:A$14&B$2:B$14&C$2:C$14,A$2:A$14&B$2:B$14&C$2:C$14,)=ROW($1:$13))/(B$2:B$14&C$2:C$14=G2&H2))


K2=SUMPRODUCT((B$2:B$14&C$2:C$14=G2&H2)/COUNTIFS(A:A,A$2:A$14,B:B,B$2:B$14,C:C,C$2:C$14))


留言