Adding the value of a cell with both text and numbers

[HiPix Photography]

Hi all, I am desperate, so I hope you can help me out...

I am trying to create a quoting system that I can convert to a HTML page for my website.
I have learnt how to create a drop down box, and done so, with text and an amount
e.g 4Hr Corporate event photography R3000-00.

The R3000-00 is the monetary value
I have five similar options in the drop down box, validated as a list

I want to now insert a formula on the page, so if someone chooses the above dropdown item, I can add the R3000-00 to another total elsewhere in the page.

Is there a way to do this, and could you please explain it in a way I understand?

I would greatly appreciate any help offered

[Pete_UK]

You need to give further examples, so we can see a pattern. If they are all like that then you can use:

=RIGHT(A1,LEN(A1)-SEARCH(" R",A1)-1)

to extract the right-most characters from the string (assumed to be in cell A1).

Hope this helps.

Pete

[HiPix Photography]

Pete,

I have uploaded the worksheet with the data, maybe this will better explain what I am trying to achieve

[XOR LX]

Hi,

Nice-looking sheet by the way!

So where are you trying to put this formula? And what precisely should the result be, and why?

Regards

[HiPix Photography]

Where there is either a tickbox, or a drop down tab, I want to be able to add them together at the bottom of the sheet. The idea is for the client to tick or select which service they would like and it gives them a running tally at the bottom, depending on what they selected.