Summation of first and last values of each cell of a selected range

[Bamerand]

I have a combination of value such as '1/3 in A1, '3/3 in A2 and '3/6 in A3. Is there a way to sum the that are 1+3+3 so that in the cell I would have 7 and the next cell 3+3+6 that would equal to 12? Basically, I need to sum the 1st values of the A1, A2 and A3 and in the other cell 2nd values of the same cells. Anybody has any clues?

 

[S.H.A.D.O.]

How about something like...

=SUM(LEFT(A1)+LEFT(A2)+LEFT(A3))

...and...

=SUM(RIGHT(A1)+RIGHT(A2)+RIGHT(A3))

I hope this helps.

 

[Bamerand]

Dear S.H.A.D.O,
The offered option works well, but only in a limited number of cells (5 x 5 table or anything about it), however, for me to specify each cell is burdensome with a table that dimensions are about 250 x 10000. Is there a way to calculate values value in one various cells? The format of the values are formatted such as “1/3”, “3/3” and “3/6”, so in the end the formula or function need to sum value preceding the slash sign and another function that sums the values succeeding the slash sign? For the three values I showed, for the first function should result in “1+3+3” so that in the cell the function would have summed to 7 and the next cell “3+3+6” that would equal to 12?
I look forward to hearing suggestions and offers.