Help adjusting sumproduct formula

[michaelsmith559]

In column A & column B I have the cells filled with combinations, ex (1, 2, 3, 4, 5) etc. I used a formula to count all the values in position 1 which works great after receiving help on a different post. When I adjust the formula to account for counting the character in position 2, it counts it incorrectly. Some characters may have 20 in that position and I think it is only counting the 2 not the 20. Here are the formulas I have tried. Also, sumproduct works fine on doing the first character in the string. It is just not working correctly when I try adjusting to count the 2nd character in the string.

mm combinations.xlsm
	AB	AC
3	98021	95810
4		235420
Sheet2

Cell Formulas
Range	Formula
AC3	AC3	=SUMPRODUCT(--(LEFT(RIGHT(A:A,LEN(A:A)-3),FIND(",",RIGHT(A:A,LEN(A:A)-3))-1)=N4&""))
AC4	AC4	=SUMPRODUCT(--((MID(A:A,4,LEN(N4)))=N4&"")+((MID(B:B,4,LEN(N4)))=N4&""))

 

[Peter_SSs]

I think that it would be helpful to see a small sample of data (say 10-15 rows) from columns A and B, what the existing formulas result in and the expected results. You can hide all the columns between column B and column AB before producing your XL2BB mini sheet.