Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding Value within a single cell...
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 |
#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 . |
#3
|
|||
|
|||
Better yet, use:
=EVALUATE("SUM("&INDIRECT("rc[-1]",0)&")") This will always evaluate the cell one column to the left. Jason -----Original Message----- 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 . . |
#4
|
|||
|
|||
Another possibility is to copy, paste special, values into the other cell and
then use edit, replace to change the commas into plus signs (in the other cells only) and then add an equals sign to the front of the equation. "Jason Morin" wrote: 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 . |
#5
|
|||
|
|||
Thanks for the replies, very helpful.
"Brian" wrote in 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 |
Reply |
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 |