重疊數 (9006)

D2{=SUM((A$2:A$9=A2)*(B$2:B$9-C2<=0)*(C$2:C$9-B2>=0))-1

另解{=COUNT(1/(A$2:A$9=A2)/(B$2:B$9-C2<=0)/(C$2:C$9-B2>=0))-1

另解=COUNTIFS(A$2:A$9,A2,B$2:B$9,"<="&C2,C$2:C$9,">="&B2)-1