Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Adding digits in a cell. (Excel XP)

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    In cell A1 I have a value, which is a value, and not a calculation or a reference. It
    Bob Wall

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Adding digits in a cell. (Excel XP)

    Put in A2:
    <pre>=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1))</pre>


    Steve

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Re: Adding digits in a cell. (Excel XP)

    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

    Thank you. Now I'll spend two days trying to figure out what the formula is doing. I'll gain some knowledge, and maybe I can pass it along to somebody else.

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    Bob Wall

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •