區間日期 統計 (15115)

J5:K8=SUMPRODUCT(SUMIFS($F:$F,$E:$E,J$4,$D:$D,"<="&$H5:$I5-{1,0})*{-1,1})

另解=SUMIFS($F:$F,$D:$D,">="&$H5,$D:$D,"<="&$I5,$E:$E,J$4)

另解{=NPV(-2,SUMIFS($F:$F,$E:$E,J$4,$D:$D,"<="&$H5:$I5-{1,0}))