Excel 2007 : How to add a two values in one cell

**LingXia0yu** · 08-05-2010, 11:48 AM

Hi guys,

I am using MSoffice 2007, i want to add two numbers/ values in one cell, like top will be one value and bottom will be another value this will be coming from another location with formula.

Like the example :

24500/200 like this we have to display in one cell, as the top value will be added with =X+X+ and so on, same like that for bottom also, but the values will be different and have seprate .

Can any one help me out

Thanks

**NBVC** · 08-05-2010, 11:52 AM

So you want to add 24500 + 200 ?

**LingXia0yu** · 08-05-2010, 11:56 AM

No adding, top value will be seprate and bottom value will be seprate,, top value will be added from another cells, same like that bottom value also added from some other cells, both are different but have to show in one cell, by seprating / (Big bar in middle)

**NBVC** · 08-05-2010, 12:09 PM

Do you mean maybe?

If you have say in A1:C1, 1/2, 5/4, 5/7... then result would be 12/13

==SUMPRODUCT(--(LEFT(A1:C1,FIND("/",A1:C1)-1)))&"/"&SUMPRODUCT(--(MID(A1:C1,FIND("/",A1:C1)+1,10)))

**LingXia0yu** · 08-05-2010, 12:33 PM

\1

Hi

Thanks for your reply, but i did not works, can u pls show see the example in picture
And pls guide me thanks for your help

**NBVC** · 08-05-2010, 12:36 PM

That's a very tiny pic... I need better glasses...

Well it looks like then:

=SUM(B2:B10)&"/"&SUM(C2:C10)

adjust ranges to suit.

**LingXia0yu** · 08-05-2010, 12:42 PM

wow, thanks NBV works great, but i want the values to show separte top one above totally and bottom down by seprating the ///

**NBVC** · 08-05-2010, 12:47 PM

You will need to merge the cells together... select the cells and go to Format|Cells and select Merge in the Alignment tab.

While there, go to the Border tab and click bottom left corner button that will add a diagonal line through the cells.

Then use formula like:

=SUM(B1:B4)&REPT(CHAR(10),3)&SUM(D1:D4)

you may need to adjust the 3 to smaller or bigger to get the numbers to line up the way you want.

**LingXia0yu** · 08-05-2010, 12:53 PM

Bro, thanks you very much, i just modified like this and it fits very good.
=SUM(K8:K13)&REPT(CHAR(1),5)&SUM(L8:L13).

Hope for some one it will help.

Bro thanks a lot. I will be visiting this site frequently, I extend my hands for friendship if u like u can add me in my yahoo id which i given in PM.
Thanks