- =SUM(IFERROR(1/COUNTIFS(A:A,TEXT(A2,">=e-m-!1"),A:A,TEXT(EDATE(A2,1),"<e-m-!1"),C:C,INDEX(C:C,IFERROR(MATCH(TEXT(A2,"e-m")-1,A:A),1)+1):INDEX(C:C,MATCH(TEXT(EDATE(A2,1),"e-m")-1,A:A)),C:C,"<>",C:C,"<>其他"),))
复制代码 以月份放一起可以
数组公式
组合键CTRL+SHIFT+回车结束后下拉即可`` |