Summing within a Cell

[Frank Price]

Hi,

I have some cells that look like this:

$10 red
$4 Blue
$13 Silver

Is there a way to sum the dollar values while ignoring the text?

Thanks,

Tom

 

[Guest]

One way ..

Assuming source data in A2:A4

Put in say, A1:
=SUMPRODUCT(--MID(A2:A4,2,SEARCH(" ",A2:A4)-1))

Note that source data is assumed representative (as posted) throughout the
range to be summed, otherwise we'd get #VALUE!