Try this:

=SUMPRODUCT((ISTEXT(A1:A11)*(RIGHT(A1:A11,LEN(A1:A 11)-1))))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"excelFan" wrote in message
...
in column A (A1:A11)
12
c8
22
c1
54
c19
c6
25
c3
c7
55
how to get the sum only for those number which begins with "c"?
many thanks for any help