Sum Of Digits In A Cell In Excel

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.

Capture

Enter the formula =1+MOD(A2-1,9) in the cell B2 and you will get the desired result.

Capture




Now drag the formula till where you have the data in column A.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply