+ Reply to Thread
Results 1 to 19 of 19

SUM of values in a comma delimited cell

Hybrid View

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Columbus, Ohio; USA
    MS-Off Ver
    Excel 2002
    Posts
    70

    Re: SUM of values in a comma delimited cell

    I have tried to put in some of the code but I can't get it to work for me. What am I doing wrong?

    Let's assume I do indeed make A1 show the following:
    _A,_B,_D (I'm going to skip "C" because I have no reason, but Excel does not allow it.)
    Sometimes A1 will have _A,_B or even _D,_I or even _A,_B,_E,_F,_K.

    I will go down the line starting in E1, then F1, etc to define that those cells are what determine what value A through K will have. Perhaps I need to say that those cells need to define what (underscore) _A through (underscore) _K are?

    I can understand the thought that I don't need the B1 expression of _A+_B+_D etc. So I'll just skip to the SUM that I want and say that B1 will simply express the SUM of the values of the letters in A1.
    Do I put =EVAL in B1? Is that a formula? Is EVAL a concept that involves addition?

    To clarify, _A and all the other letters could have a two digit value, one digit, 3 digit, etc. I'd like the letters to accomodate any number size. And further, any number of letters could be shown delimited in the cell, so I will need to prepare by defining out as many letters as necessary.

    Maybe I'm also not using the Name feature correctly.

    Sorry for the confusion.

    Dan

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: SUM of values in a comma delimited cell

    see attached ...

    (use of _ in defined names is of course optional - I use it to prevent naming issues - eg C is not valid name whereas _C is...)

    worth adding perhaps that the content of A cells need not be defined names - you could still use numerical expressions - eg 1,10,23 etc...

    EDIT:
    attachment reloaded at 2109 UK time...
    Attached Files Attached Files
    Last edited by DonkeyOte; 01-14-2010 at 05:07 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1