Query: I have got numbers in cell, i want to find total of all digits (number) in a particular cell.
e.g. If in cell A1 there is number 1234, then i want total/sum of 1+2+3+4=10 in next cell.
Answer: We can achieve this result using SUMPRODUCT formula,
formula is =SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1))
tag: #EXCEL #FOORMULA #total #of/sum of all #digits(number) in a #cell