As your A1 column is text then it can be traeted as such, if you use =SUMPRODUCT((MID(A1:A10&"000",2,1)+0=6)+0) then you will find it will work