SOLVED

New Contributor

# Help with Countif criteria

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

3 Replies
best response confirmed by WeeWillie3 (New Contributor)
Solution

# Re: Help with Countif criteria

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.

# Betreff: Help with Countif criteria

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.

# Re: Help with Countif criteria

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