I have a cell containing fractions as text, like:
2/4 + 2/4 +2/4
I want to extract fractions as numbers, and sum them.
I tried a simple:
=SPLIT(A2, "+")
that correctly split numbers in three columns
and then
=SUM(SPLIT(A2, "+"))
but got this wrong result:
4/19
Can you help understand how to get right result?