Glenn - this worked great. Now I don't have to add in another column to
convert to text; plus it's more accurate.
Thanks again.


"Glenn" wrote:

Try this:

=SUMPRODUCT(--(MID(A1:A100,4,2)="41"))

antwaan wrote:
"41" will always be the 4th & 5th characters in the cell.


"Glenn" wrote:

antwaan wrote:
I have a range of cells in column A. The values may range from:
10041, 10041B to 10041PEM

I need a formula to count the number of "41" that occurs. Please help!


Any "41", like "10412" and "14102PEM"? What about "14141B"...is that counted
once or twice?

Or are you looking for only where "41" are the 4th and 5th characters in the cell?