i have enter the record in the row, and inside the cell, i'm using
ALT+Enter to make more line for the record, but i would like to know
how to sum of the value in this cell??
e.g.

C1 C2 C3
R1 1 1 XD
R2 2 2 YY
R3 1 XY
2 A
R4 3 3

how can i get the value of A = 3, that is the sum of R3C1(1+2)
also, how can i put the dollar sign automatically in cell R3C1 if i'm
using "ALT+ENTER" to make more line.


--
kilianli
------------------------------------------------------------------------
kilianli's Profile: http://www.excelforum.com/member.php...o&userid=32328
View this thread: http://www.excelforum.com/showthread...hreadid=521135

As soon as you use Alt-Enter, the information in the cell becomes text and is
no longer sumable.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"kilianli" wrote:


i have enter the record in the row, and inside the cell, i'm using
ALT+Enter to make more line for the record, but i would like to know
how to sum of the value in this cell??
e.g.

C1 C2 C3
R1 1 1 XD
R2 2 2 YY
R3 1 XY
2 A
R4 3 3

how can i get the value of A = 3, that is the sum of R3C1(1+2)
also, how can i put the dollar sign automatically in cell R3C1 if i'm
using "ALT+ENTER" to make more line.


--
kilianli
------------------------------------------------------------------------
kilianli's Profile: http://www.excelforum.com/member.php...o&userid=32328
View this thread: http://www.excelforum.com/showthread...hreadid=521135

Then how about i'm not using ALT+ENTER, but have the same function that
allow me to input more than one line in the cell??
Any suggestion to me??


Gary L Brown Wrote:
As soon as you use Alt-Enter, the information in the cell becomes text
and is
no longer sumable.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was
this
Post Helpfull to you?''.


"kilianli" wrote:


i have enter the record in the row, and inside the cell, i'm using
ALT+Enter to make more line for the record, but i would like to know
how to sum of the value in this cell??
e.g.

C1 C2 C3
R1 1 1 XD
R2 2 2 YY
R3 1 XY
2 A
R4 3 3

how can i get the value of A = 3, that is the sum of R3C1(1+2)
also, how can i put the dollar sign automatically in cell R3C1 if
i'm
using "ALT+ENTER" to make more line.


--
kilianli

------------------------------------------------------------------------
kilianli's Profile:
http://www.excelforum.com/member.php...o&userid=32328
View this thread:
http://www.excelforum.com/showthread...hreadid=521135




--
kilianli
------------------------------------------------------------------------
kilianli's Profile: http://www.excelforum.com/member.php...o&userid=32328
View this thread: http://www.excelforum.com/showthread...hreadid=521135