Adding Formatted Fractions

Hi all,

I'm having some issues adding fractions in a way that will add the numerator as well as the denominator from 2 subtotal columns.

Attached is my workbook which will hopefully make the issue slightly clearer.

Darko

Originally Posted by Bo_Ry

Please try at J2 result 3/174

=SUMPRODUCT(--LEFT(A2:I2,FIND("/",A2:I2)-1))&"/"&SUMPRODUCT(--RIGHT(A2:I2,LEN(A2:I2)-FIND("/",A2:I2)))

or result 2/174

=SUMPRODUCT(LEFT(A2:I2,FIND("/",A2:I2)-1)*(LEFT(A1:I1,3)<>"Sub"))&"/"&SUMPRODUCT(--RIGHT(A2:I2,LEN(A2:I2)-FIND("/",A2:I2)))

Thank you so much Bo. Worked like a charm!