Sumproduct instead of countif. 1 digit numbers problem.

[fleskj]

Ha! I was wondering if there is a simple formula Thanks, xld!
Quick question though, how can I replace this "6" (with the quotes) with a cell reference?
If I've got 6 in the B6 cell for example,
=SUMPRODUCT(--(MID(A1:A10,2,1)=B6)) won't work

I've figured it out,
it should be
=SUMPRODUCT(--(MID(A1:A10,2,1)+0=B6)) for it to work

EDIT: scratch that, it leaves me with the original problem of 1 digit cells, nevermind

In VBA, Place the Keyboard cursor inside a word and press F1 for help on that word.

Thanks! I'll look into that.

[Bob Phillips]

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")))