統計共發出多少文件 (12549)

 S12=SUMPRODUCT(RIGHT(SMALL((A$2:U$2=R12)*A$3:U$9+COLUMN(A:U)/1%,COLUMN(A:U)*7))*1)

另解=SUMPRODUCT(MMULT(COLUMN(A:G)^0,N(A$3:U$9>0))*(A$2:U$2=R12))