SUM DIGITS IN ONE CELL

Using the Morefunc Add-In formula for Excel 2002:

=EVAL(SUBSTITUTE(A1,"-","+"))

Where cell A1 has the following: 1,2,3,4,5

Sum would equal 15

Google "Morefunc" English version to download Free Morefunc Add-In