Small modification to my UDF (to account for the possibility of trailing
spaces in the series of numbers)...

Function SumCell(R As Range) As Double
SumCell = Evaluate(Replace(Trim(R.Value), " ", "+"))
End Function

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Assuming Harlan's guess is correct (your cells could contain a string like
1 2 4 17 -5 2 0 -7 23 which you want to total up to get 37 as the
answer)... if you are able to use VB code (I say able because you may have
to adjust your security settings in order to be able to use VB code),
there is a simple User Defined Function (UDF) that can be implemented to
do this. Press Alt+F11 to get into the Visual Basic Editor, click
Insert/Module on its menu bar and then copy/paste the following into the
code window that opened up...

Function SumCell(R As Range) As Double
SumCell = Evaluate(Replace(R.Value, " ", "+"))
End Function

Now, go back to a worksheet, put a space-delimited set of numbers (say 1 2
4 17 -5 2 0 -7 23) into a cell (say, C5), and put this in the cell you
want the sum to appear in...

=SumCell(C5)

and the formula should evaluate to 37. You can now use this formula like
any other putting the cell you want to sum between the parentheses.

--
Rick (MVP - Excel)


"TD" wrote in message
...
I'm trying to perform a function where I input multiple numbers into one
cell
and have their sum appear in an adjacent cell. I will need to do this
repeatedly through many rows. Can someone please advise?! Many thanks.