統計數字數 一條件 (13531)

F2:G2=SUMPRODUCT((LEN($B2:$B50)-LEN(SUBSTITUTE($B2:$B50,",",""))+1)*($A2:$A50=COLUMN(A1)))

另解=SUMPRODUCT(COUNTIFS($A:$A,COLUMN(A1),$B:$B,"*"&REPT(",*",ROW(1:66)-1)))



留言