Help with Countif criteria

[WeeWillie3]

I have a column of 5 digit numbers all beginning with the same 2 digits. Also ignoring digits 4 and 5, I want to count the number of each of the different 3rd digits. How do I do this presumably using the "Countif" function?

Thanks

[#2 · Accepted solution]

@WeeWillie3 

Let's say the numbers are in E2:E100.

Enter the digits 0, 1, ..., 9 in a range, e.g. in G2:G11.

Enter the following formula in H2:

=SUMPRODUCT(--(MID($E$2:$E$100,3,1)=G2&""))

Fill or copy down to H11.

[#3]

@WeeWillie3 

MID

Hope I was able to help you and would be happy to know if I could help you.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#4]

@Hans Vogelaar 

Thanks for your detailed instructions... they worked perfectly!  I just wish I had been smart enough to seek your advice about two hours ago!!!