Excel: Help with COUNTIF formula


Hi, i have a row of data containing 8 digit numbers and i want to count the number of 10,20 or 30 at the 5th and 6th digit is there an easy way to do this? Example: data in column A 10053001 24224002 14432001 54419030 44301002 10223001 55677501 not sure what to put in for the criteria but formula from above data should output a value of 4

=COUNTIFS($A:$A,??)
i could do it by creating another formula =MID(A2,5,2) but would prefer not to as theres lots of data any help appreciated


This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of April 10, 2017.


For more resources for Microsoft Excel