 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Summing up digits in a cell
Hi, i need to add all the digits in a cell. For example, if I have a number 58 in a cell, the adjacent cell should return a value of 13. regards krishna If you only have 2 digits, try this =SUM(LEFT(A2,1),RIGHT(A2,1)) > Hi, > > i need to add all the digits in a cell. For example, if I have a number 58 > in a cell, the adjacent cell should return a value of 13. > regards > krishna Thanks gaurav, this has helped for two digits. regards krishna > If you only have 2 digits, try this > [quoted text clipped - 6 lines] > > regards > > krishna > ... this has helped for two digits. Another option for 1-2 digit numbers ... =A1-9*INT(A1/10)  SignatureDana DeLouis > Thanks gaurav, this has helped for two digits. > regards [quoted text clipped - 10 lines] >> > regards >> > krishna Try this small UDF: Function digicount(r As Range) As Integer Dim n As Integer digicount = 0 v = r.Value L = Len(v) For i = 1 To L n = Mid(v, i, 1) digicount = digicount + n Next End Function SignatureGary''s Student - gsnu200787 > Hi, > > i need to add all the digits in a cell. For example, if I have a number 58 > in a cell, the adjacent cell should return a value of 13. > regards > krishna =SUMPRODUCT(--MID(A4,ROW($A$1:INDEX($A:$A,LEN(A4),1)),1)) SignatureWag more, bark less > Hi, > > i need to add all the digits in a cell. For example, if I have a number 58 > in a cell, the adjacent cell should return a value of 13. > regards > krishna Thanks a ton Brad. Was looking for something as useful and simple as this. regards krishna > =SUMPRODUCT(--MID(A4,ROW($A$1:INDEX($A:$A,LEN(A4),1)),1)) > [quoted text clipped - 4 lines] > > regards > > krishna You're welcome SignatureWag more, bark less > Thanks a ton Brad. Was looking for something as useful and simple as this. > regards [quoted text clipped - 8 lines] > > > regards > > > krishna |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.