Monday, March 28, 2016

Excel formula to get total of/sum of all digits(number) in a cell

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

No comments:

Post a Comment