SUM DIGITS IN ONE CELL

SUBMITTED BY: Guest

DATE: March 12, 2014, 2:51 p.m.

FORMAT: Text only

SIZE: 242 Bytes

Raw Download

HITS: 1180

Report
  1. Using the Morefunc Add-In formula for Excel 2002:
  3. =EVAL(SUBSTITUTE(A1,"-","+"))
  5. Where cell A1 has the following: 1,2,3,4,5
  7. Sum would equal 15
  9. Google "Morefunc" English version to download Free Morefunc Add-In
comments powered by Disqus