# Formula

Closed
Goutam Goswami - Apr 19, 2011 at 07:18 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 19, 2011 at 10:23 AM
Hello,

In Cell A3 There Is 1/2
In Cell A4 There Is 10/20
In Cell A5 There Is 100/200

Now I Want To Add Left Side Data And Right Side Data In From 3 Cells In A6 Separately I.E Sum Of Left Side Data / Sum Of Right Side Data.

## 1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 19, 2011 at 10:23 AM
Hi Goutam Goswami,

Is this paticular case you could use this formula:
=SUM(LEFT(A3,1)+LEFT(A4,2)+LEFT(A5,3))
And then do the same for the right side.

But this won't do if the length of the numbers change.

Personally I would use the text delimiter option under the Data top menu.
This will put the 1, 10 and 100 in column A and 2, 20 and 200 in column B.
Now a simple SUM formula will do.

Can you work with this?

Best regards,
Trowa