We will see in this post one of the easiest way to sum up all the digits in a number in excel.
Let’s see how we can get the sum of digits in a cell in excel.
We will see a simple formula to find out the sum of all the digits in a number in excel e.g. 432=4+3+2=9.
Enter the formula =1+MOD(A2-1,9) in the cell B2 and you will get the desired result.
Now drag the formula till where you have the data in column A.
Hope this helped.