+ Reply to Thread
Results 1 to 4 of 4

Adding values of cells with similiar text

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    oklahoma city
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Adding values of cells with similiar text

    Hello,

    Here is my example; exampleBook2.xlsx

    I would like to add up total numbers associated with the different codes. For example line one should be: 16 CT, 8 OU, 1 Trng, 8 CE, 8 LS, 8 LA. The RDO code is not necessary, only fields with numbers. Also some cells with contain more than 1 code, which can probably make the formula much more complicated

    To be a little more specific this is a time sheet record, LA, OU, CT, all reference different time of "time-off" or "time-earned". Incase that information may help with the development of a formula.

    Thank you in advance!
    Last edited by kuyleh; 06-15-2012 at 05:10 PM.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Adding values of cells with similiar text

    Is this one cell or multiple?

  3. #3
    Registered User
    Join Date
    06-15-2012
    Location
    oklahoma city
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Adding values of cells with similiar text

    multiple, from A1 to L3, it didn't really paste correctly or at least how i wanted it to. I was thinking maybe a formula for each major group (LA,LS,OU) but the less the better of course.

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Adding values of cells with similiar text

    Please see attached.
    If you like the answer please click the star on the left hans side
    Attached Files Attached Files

+ 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