K2=SUM(MMULT(COLUMN(A:I)^0,N(MID(SUBSTITUTE(A2:J2,",",REPT(" ",99)),ROW($1:$9)*99-98,99)<>"")))
L2{=SUM(IFERROR(MID(SUBSTITUTE(A2:J2,",",REPT(" ",99)),ROW($1:$9)*99-98,99)*1,))
L2另解=SUMPRODUCT((0&TRIM(MID(SUBSTITUTE(A2:J2,",",REPT(" ",99)),ROW($1:$9)*99-98,99)))*1)
留言
張貼留言