出車日數 指定年月 (11934)

V2=INDEX(FREQUENCY(ROW(INDIRECT(D2&":"&F2)),EOMONTH(DATE(O$3,O$7,1),{-1,0})),2)

R2=SUMIF(A:A,Q2,V:V)

S2:T4{=ABS(MIN(IF(($A$2:$A$12=$Q2)*(TEXT($D$2:$D$12,"YYYM")=$O$3&$O$7),K$2:K$12*-1^(D$1=$E$1))))



留言