You might want to consider using LEN(A1) in both arguments - that way
the arguments can be of different length.

In article ,
"Biff" wrote:

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=MID(A2,ROW( INDIRECT("1:"&
LEN(A2))),1)))