If it is only one letter in front... try:

=SUMPRODUCT(--MID($C$1:$C$6,2,10))