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.