+ 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

    Thank you all for thinking on this!

    I was trying to figure out and try various solutions presented by you.

    So what I would have in cell A1 would be A,B,C. ("A,B,C" is if there is just three. There could be less or more than 3, ie "A,B" or "A,B,C,D" etc.)
    In B1, I would like to see however many letters are delimited in A1 to be shown as A+B+C, or if there were 4 letters show up in A1, then B1 would show A+B+C+D.
    Then in C1, if I define under the "Insert Name" command that A will always be the value I enter in, say, E1, B will be the value I enter in F1, C will be the value I enter in G1, and D, will be the value I enter in H1, etc, then in the case of A=1, B=2, C=3, and D=4, I want to see the number 10 in C1.

    Is this all possible with formulas?

  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

    I'm not sure I understand the need for B1 string...

    If as advised you create Names _A, _B, _C etc... (you shouldn't / can't use C for ex.) such that _A refers to =$E$1, _B to $F$1 etc... then you can use what you already have ie:

    A1: _A,_B,_C,_D
    B1: =Eval
    ... the only limitation to the x,y,z rather than x+y+z is that the former is constrained in terms of how many items you can include in the delimited list but I suspect that won't be an issue here, ie:

    =SUM(1,2,3)
    is the same as

    =1+2+3
    (edit: in fact the SUM route has added advantage over + given the lack of explicit coercion taking place - ie non-numeric names won't generate #VALUE!)
    Last edited by DonkeyOte; 01-14-2010 at 11:17 AM.

+ 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