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