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


.

.