指定年月 人數 (14061)

O4:P4=NPV(-2,SUMIFS($C:$C,$K:$K,O2&"*",$A:$A,">="&EDATE($N1&$O1&"1日",{1,0})))

另解=NPV(-2,SUMIFS($C:$C,$K:$K,O2&"*",$A:$A,">="&EDATE(LEFT($N1,4)&-LEFTB($O1,2),{1,0})))