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