Search code examples
excelsummultiplication

Sum numbers in one column

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 ?

Solution

  • Try it as,

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