行列數 每行列任一非空 計1 (13162)

L2=SUMPRODUCT(N(MMULT(N(A1:J10<>""),ROW(1:10)^0)>0))&"行"&SUMPRODUCT(N(MMULT(COLUMN(A:J)^0,N(A1:J10<>""))>0))&"列"

L14{=COUNTIF(A13:A20,"<>")&"行"&MAX((A13:J20<>"")*COLUMN(A:J))&"列"