單元格裡數字總和 (12575)

日期：

C2=SUMPRODUCT(--TEXT(RIGHT(TEXT(MID(SUBSTITUTE(B2&",",",",REPT(" ",9)),ROW($1:$520),9),),8),"[>];;;!0"))



留言

張貼留言