二場地都有到的人數 依偵測到電話 (12789)

K4=SUMPRODUCT(COUNTIFS(B:B,G2:G21,C:C,">="&I12,C:C,"<="&I16))

K8=ROUND(K4/SUMPRODUCT(COUNTIF(B:B,G2:G21))/1%,2)&"%"