Another option that isn't so rigid in its implementation...

Download and install the free Morefunc.xll add-in from:

http://xcell05.free.fr/morefunc/english/index.htm

Alternate download site:

http://www.download.com/Morefunc/300...-10423159.html

The use this formula (entered anywhere!):

=EVAL(SUBSTITUTE(E1,",","+"))

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
One way...

The formula *must* be entered in the cell to the immediate right of the
cell that you want to sum. For example:

E1 = 87563, 8930, 98279

The formula *must* be entered in cell F1.

Create this named formula.
Select cell B1. ***this is important***
Goto the menu InsertNameDefine
Name: ESum (or whatever name you want to use)
Refers to:

=EVALUATE(SUBSTITUTE(A1,",","+"))

OK out

Then:

E1 = 87563, 8930, 98279

Enter this formula in **F1** :

=ESum

--
Biff
Microsoft Excel MVP


"pandd15" wrote in message
...
My spreadsheet contains multiple numbers in one cell they are all
seperated
by a coma. Is there a formula that will add these numbers?

87563, 8930, 98279 are in one cell I'd like to have the total in another
colum, the total of numbers not the sum, e.g. 3

Thanks,