It doesn't work for the same reason that your original formula doesn't work, you are comparing numeric items with strings. You need to string it
=SUMPRODUCT(--(MID(A1:A10,2,1)=TEXT(B6,"General")))
It doesn't work for the same reason that your original formula doesn't work, you are comparing numeric items with strings. You need to string it
=SUMPRODUCT(--(MID(A1:A10,2,1)=TEXT(B6,"General")))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber