Excel to get Sum of Digits - Need suggestion

CA CS CIMA Prakash Somani (Landmark Group) (23512 Points)

03 November 2009  

Pls go through this file and let me know how can you make it simplified.

You can get sum of digits in a cell e.g. if you have 1564 in a cell then the total of 1+5+6+4=16 is automatically shown by the formula.

Invited your suggestions to make it simple :) Cheers :)