Hi

It's a three stage process.

1. In A1, B1, C1, D1 etc. put your text fractions as you have done.
2. A2 = LEFT(A1), B2 = LEFT(B1), C2 = LEFT(C1) etc.
3. A3 = VALUE(A2), B3 = VALUE(B2), C3 = VALUE(C3) etc.
Now you can sum row A3.

Do the same for the denominator and you're there.
Actually you would probably want to combine the second and third
columns. ie A2=VALUE(LEFT(A1))

Enjoy


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=374128