Oct 30 2020 09:44 AM
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
Oct 30 2020 10:04 AM
SolutionLet'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.
Oct 30 2020 10:16 AM
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.
Oct 30 2020 10:47 AM
Thanks for your detailed instructions... they worked perfectly! I just wish I had been smart enough to seek your advice about two hours ago!!!
Oct 30 2020 10:04 AM
SolutionLet'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.