| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sum Value using ALT+ENTER
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. -- kilianli ------------------------------------------------------------------------ kilianli's Profile: http://www.excelforum.com/member.php...o&userid=32328 View this thread: http://www.excelforum.com/showthread...hreadid=521136 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
| how to enter numbers value for calculation? | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| "Enter" in Macros | Excel Discussion (Misc queries) | |||
| Enter last name, auto fill full name & address--HOW? | Excel Discussion (Misc queries) | |||
Threaded Mode
