How do I find the sum of all digits in a number?

Originally Posted by Paragpd

Ron, it still works...

Assuming your numbers will never contain more than 15 digits, you could use this formula as well...

=SUMPRODUCT(0+(0&MID(A1,ROW(1:15),1)))