Quote Originally Posted by Pete_UK View Post
You can put this formula in G4:

=SUMPRODUCT(--(MID($A$5:$A$20,2,1)=F4))

Hope this helps (for now).

Pete
What if I didn't want mid . Example p2dV5..... This time I need V as my criteria