| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
One way:
1. Press Ctrl+F3 and define the name "addcell" (no quotes) as: =EVALUATE("SUM("&A1&")") 2. In the cell to the right put: =addcell 3. Be careful. From H. Grove: "Pasting formulas with names referring to XLM functions into different worksheets than that containing the copied cells happily crashes Excel 2000 and 97". HTH Jason Atlanta, GA -----Original Message----- I have a spread sheet with multiple values in individual cells separated by commas. (i.e. 1,6,23,2,63,399) Can I add these values and display the result in another cell while leaving the original cell intact? Thank.s . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to separating first and last name (in a single cell... | Excel Discussion (Misc queries) | |||
| how to add two data validation lists to a single cell? | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
