Hi Timberline,

First off, I calculate a different sum of the products. In column 15 you multiply 0 by 4 and get a 4. My calculation puts this portion at 0, and my sum of the products becomes 328. Anyway, here is my formula to generate the checksum digit:

=IF(MOD(SUMPRODUCT(B4:I4,B5:I5)+SUMPRODUCT(K4:R4,K5:R5),11)=10,"X",MOD(SUMPRODUCT(B4:I4,B5:I5)+SUMPRODUCT(K4:R4,K5:R5),11))

In this example, this equates to 9.

Have I missed something, or are we on the right path here?

Larry.

## Like this thread? Share it with others