多格 計幾個數字 (13701)

日期：

E2=SUMPRODUCT(LEN(A2:D2)-LEN(SUBSTITUTE(A2:D2,",",))+(A2:D2<>""))

另解{=SUM(IF(A2:D2<>"",LEN(A2:D2)-LEN(SUBSTITUTE(A2:D2,",",))+1))



留言

張貼留言