Sum numbers in one column

Question

I've a Excel spreadsheet and there's summation and multiplication in my last result a have a big number like this

482362534 

and what i want to sum this number for example

4+8+2+3+6+2+5+3+4 

and show me the result 37 in another column, is there's a function to do this ?

Answer 1

Try it as,

=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))