Excel 2007 Right function with Embeded Find Function help

[Arazmus]

Hi,

I have a range of cells, for this example I will use 2.

Cell E17 = 77/170
Cell E18 = 8/9

Using the following formula: =SUM(RIGHT(E17,FIND("/",E17)))+SUM(RIGHT(E18,FIND("/",E18)))

This bring back an #VALUE! Error as the second part of the formula keeps picking up "/9" however the first part works fine, displaying "170"

Now if I use:
=SUM(RIGHT(E17,FIND("/",E17)))+SUM(RIGHT(E18,FIND("/",E18)-1))
It all works. The problem is that I need this to be automatic using the above way means having to add a "-1" to every formula for a cell with only 1 char to be added.

Using the formula:
=SUM(RIGHT(E17,FIND("/",E17)-1))+SUM(RIGHT(E18,FIND("/",E18)-1))

does not produce correct results either as although the second part works fine ("9") the first part is picked up at "70" not "170"

I cannot see why this is happening, the first formula should work but doesn't.. I need this to add up around 40 cells that can have a various length on the right (usually 1, 2 or 3 chars)

Any Ideas?

[Andy Pope]

You need to take into account the length of the text in the cell

=SUM(RIGHT(E17,LEN(E17)-FIND("/",E17)))+SUM(RIGHT(E18,LEN(E18)-FIND("/",E18)))

[Arazmus]

you my friend are brilliant!!

that worked straight away.