Sum Value using ALT+ENTER

  • Thread starter Thread starter kilianli
  • Start date Start date
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
R3 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.
 
The new line character (Alt + Enter) is changing the number to a text value.
Why don't you just adjust the height of the row. Click FORMAT in the menu,
select ROW, click HEIGHT and enter the row height value.

You can adjust where the text appears in the larger cell by clicking FORMAT,
select CELLS and then click on the ALIGNMENT tab. Use the horizontal and
vertical text alignment options to place the text correctly within the cell.
 
I'm using more line as the record need to have the list inside, i need
to show out different condition inside the cell. so need to use more
need to list out different.
Any suggestion to me that allow me input a list of condition in the row
???
 
Back
Top