Thread: Summing up digits in a cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
  
Posts: 846
Default Summing up digits in a cell
=SUMPRODUCT(--MID(A4,ROW($A$1:INDEX($A:$A,LEN(A4),1)),1))
--
Wag more, bark less


"Sai Krishna" wrote:

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
Reply With QuoteReply With Quote