how to sum the value
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 |
how to sum the value
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 |
All times are GMT +1. The time now is 10:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com