how to sum the value

K

kilianli

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.
 
G

Guest

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

kilianli

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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Value using ALT+ENTER 3
Sumif with multiple sum ranges in a sheet 4
formula to make the value in a cell, to a row in a sum function 5
Manual Transpose 2
SUMIF "value if false" not working 2
compare cells and sum if equal 4
How do I find max then sum cells above & to the left? 5
daverage worksheet function 1

Top