Home » Forums » Open Source Learning Center » Question and Answer

Adding digits in the same cell

Submitted by anjana harry on 12 July, 2012 - 00:54

I have the numbers from 0-999 in a column and i need to add the digits of each number and make a second column. eg. the sum of the digits of 123 is 6
What is the formula for doing this for any number of digits in a cell?

‹ open any .bat file with the help of excel button Paste specific text to clipborad on click of excel button ›
»
Nick's picture

assuming your data starts in

Submitted by Nick on 12 July, 2012 - 13:15.
assuming your data starts in A1.. enter this in B1, and copy it down:

=IF(A1<10,A1,LEFT(A1,1)+RIGHT(A1,1))+IF(A1>99,MID(A1,2,1),0)

Say thanks, by "liking" here:

; - >

Nick

»