Can anyone tell me why this formula works. It was given to me as a solution
and it works I just dont understand why.

I was trying to count how many charaters in a cell are letters.

For example JXR1234 = 3

=SUMPRODUCT(LEN(SUBSTITUTE(A22,{0;1;2;3;4;5;6;7;8; 9},"")))-9*LEN(A22)

I understand how sumproduct works, just not in this instance.

Thanks for any help you can send my way.

Confused in Phoenix.