统计数据在多少个月份出现 (9580)

F2{=SUM((B$2:B$16=E2)/COUNTIFS(A:A,A$2:A$16,B:B,B$2:B$16))

另解=SUMPRODUCT((MATCH(A$2:A$16&B$2:B$16,A$2:A$16&B$2:B$16,)=ROW($1:$15))*(B$2:B$16=E2))