Thanks a ton Brad. Was looking for something as useful and simple as this.
regards
krishna



"Brad" wrote:

=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