求EXCEL 公式,计算每个工龄段的在职人数?H3=SUMPRODUCT((IFERROR(DATEDIF($C$3:$C$15,H$2,"m"),"")=(ROW(A3)-3))*((IF($D$3:$D$15=0,H$2+1,$D$3:$D$15)-H$2)>=0))ctrl+shift+
2023-01-08
求EXCEL 公式,计算每个工龄段的在职人数?H3=SUMPRODUCT((IFERROR(DATEDIF($C$3:$C$15,H$2,"m"),"")=(ROW(A3)-3))*((IF($D$3:$D$15=0,H$2+1,$D$3:$D$15)-H$2)>=0))ctrl+shift+
2023-01-08