尾数相同数與和 (10968)

M2=SUMPRODUCT((RIGHT(A2:J2)-L2=0)*A2:J2)

另解M2{=SUM((MOD(A2:J2,10)=L2)*A2:J2)

另解M2{=SUM(SUMIF(A2:J2,L2+(ROW($1:$10)-1)*10))

N2=SUMPRODUCT(N(MOD(A2:J2,10)=L2))

格式化 A2:J11=MOD(A2,10)=$L2