We will see in this post one of the easiest ways, 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. 11112=1+1+1+1+2=6.
You can do this using two method
- Using Formula
- Using Macro Custom Function
Read: How To Remove Protected View In Excel
How To Sum All Numbers In A Cell in Excel
Using Formula
Using bellow formula you can easily sum cell numbers
=IF(COUNT(A8),SUMPRODUCT(--MID(A8,ROW(INDIRECT("1:"&LEN(A8))),1)),0)
Using Macro Custom Function
Public Function SumCellValue(number1 As Double)
CellValue = number1
CountCellValue = Len(CellValue)
CellVT = 0
For RowValue = 1 To CountCellValue
Char = Mid(CellValue, RowValue, 1)
CellVT = CellVT + Char
SumCellValue = CellVT
Next RowValue
End Function
If you like this function so kindly share your feedback in bellow comment box.
