Excel: How to sum two different numbers in same cell?

Question

I have some info like below:

3/7
4/6
5/1

And I want a formula that will add them up to a total based on the numbers on either side of the slash. So the result cell from the above would be: 12/14. Anyone know how I can do this? Please let me know if this is not clear. Thanks!

Solution

Assuming data in A1:A3, you could enter this in A4:

=SUMPRODUCT(--LEFT(A1:A3,FIND("/",A1:A3)-1))&"/"&SUMPRODUCT(--REPLACE(A1:A3,1,FIND("/",A1:A3),0))