View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Ptacek Bob Ptacek is offline
external usenet poster
 
Posts: 6
Default Sum of digits in a number

Example: a number 1234 would sum individual dighits to a value of 10.

I thought there would be a function in Excel that would do that but can't
seem to find it. I don't want write a macro with MID functions to do the
summing. Is there such a function in Excel?

Thank you in advance for any help