Hi,
try

=SUMPRODUCT(--(LEFT(A1:A11)="c"), --MID(A1:A11,2,256))

change the letter to fit your needs

"terilad" wrote:

Hi,

I have a range of cells that need to be input by data pounds preceded by a
letter V, M, C. e.g. C £100.00, or V £50.00.

How can I sum these figures on another sheet under the heading C V and M?

Many thanks


Mark