One way:

A1: 1+5+8

=SUMPRODUCT(--MID(SUBSTITUTE(A1,"+",0),ROW(INDIRECT("1:" & LEN(A1))),1))

Result = 14

--
Biff
Microsoft Excel MVP


"Clint" wrote in message
...
Using Excel 2007 with SP2, how can I enter and summarize multiple numbers
within one cell?
IE. 1+5+8+...=____
Or is this even possible?
Thanks for anything on this. Jim