If these are text values; try the below formula

Col A Col B Col C
C £100.00 C =
V £50.00 V =
V £50.00
C £100.00

=SUM(IF(LEFT($A$1:$A$10,1)=B1,SUBSTITUTE($A$1:$A$1 0,B1&" £",)+0))

--
If this post helps click Yes
---------------
Jacob Skaria


"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