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

  • Find/Locate Gaps In Sequential Time List In Excel

    This post demonstrates how we could find gaps in a sequential time list in excel. By sequential time, I mean […]

    Share The Knowledge
  • Highlight/Color Negative Value In Excel

    This post demonstrates how to highlight/color negative values in excel. By highlighting negative values in color we enable those values […]

    Share The Knowledge
  • Insert Watermark/Image In Excel

    The post demonstrates how to insert watermark in excel sheet.Watermark is used to prevent plagiarism and also it serves the […]

    Share The Knowledge
  • Highlight Mondays in Excel

    Highlighting the days in excel is a frequent operation.We come across several situation in which we need to highlight some […]

    Share The Knowledge

Leave a Reply