符合率 依數據數自動判斷 (12379)

G2=SUMPRODUCT(COUNTIFS(C2,">="&E:E,D2,"<="&E:E))/COUNT(E:E)

另解=SUMPRODUCT(N(MMULT(N(E2:E11-C2:D2>0),{1;1})=1))/COUNT(E:E)

另解{=COUNT(VDB(,,C2,D2,E2:E11))/COUNT(E:E)