Summing within a Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Price - 21 Dec 2006 00:52 GMT

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

Reply to this Message

Max - 21 Dec 2006 01:16 GMT

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!

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi,
>
[quoted text clipped - 9 lines]
>
> Tom

Reply to this Message

Rate this thread: