software

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 quot;ALT ENTERquot; to make more line.--
kilianli
------------------------------------------------------------------------
kilianli's Profile: www.excelforum.com/member.php...oamp;userid=32328
View this thread: www.excelforum.com/showthread...hreadid=521135As 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?''.quot;kilianliquot; wrote:

gt;
gt; i have enter the record in the row, and inside the cell, i'm using
gt; ALT Enter to make more line for the record, but i would like to know
gt; how to sum of the value in this cell??
gt; e.g.
gt;
gt; C1 C2 C3
gt; R1 1 1 XD
gt; R2 2 2 YY
gt; R3 1 XY
gt; 2 A
gt; R4 3 3
gt;
gt; how can i get the value of A = 3, that is the sum of R3C1(1 2)
gt; also, how can i put the dollar sign automatically in cell R3C1 if i'm
gt; using quot;ALT ENTERquot; to make more line.
gt;
gt;
gt; --
gt; kilianli
gt; ------------------------------------------------------------------------
gt; kilianli's Profile: www.excelforum.com/member.php...oamp;userid=32328
gt; View this thread: www.excelforum.com/showthread...hreadid=521135
gt;
gt;


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:
gt; As soon as you use Alt-Enter, the information in the cell becomes text
gt; and is
gt; no longer sumable.
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was
gt; this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;kilianliquot; wrote:
gt;
gt; gt;
gt; gt; i have enter the record in the row, and inside the cell, i'm using
gt; gt; ALT Enter to make more line for the record, but i would like to know
gt; gt; how to sum of the value in this cell??
gt; gt; e.g.
gt; gt;
gt; gt; C1 C2 C3
gt; gt; R1 1 1 XD
gt; gt; R2 2 2 YY
gt; gt; R3 1 XY
gt; gt; 2 A
gt; gt; R4 3 3
gt; gt;
gt; gt; how can i get the value of A = 3, that is the sum of R3C1(1 2)
gt; gt; also, how can i put the dollar sign automatically in cell R3C1 if
gt; i'm
gt; gt; using quot;ALT ENTERquot; to make more line.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; kilianli
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; kilianli's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32328
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=521135
gt; gt;
gt; gt;--
kilianli
------------------------------------------------------------------------
kilianli's Profile: www.excelforum.com/member.php...oamp;userid=32328
View this thread: www.excelforum.com/showthread...hreadid=521135