Quote Originally Posted by xld View Post
SUMPRODUCT will do it

=SUMPRODUCT(--(MID(A1:A10,2,1)="6"))
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