+ Reply to Thread
Results 1 to 3 of 3

-Sumif- -match-: Values shall be added up if relating information matches with other cells

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    Berlin
    MS-Off Ver
    Excel 2010
    Posts
    5

    -Sumif- -match-: Values shall be added up if relating information matches with other cells

    Hello,

    I've posted an related thread earlier, now I stuck again. Here's the link to the solved earlier problem.
    Now I want to add up values relating to the newly compiled information. I attached the new and commented excel spreadsheet for visualization. Everything stayed the same except columns D, F and G were added to the sheet.
    Find matches between two columns to insert third but related information into a new column(BB)_.xlsx
    The earlier compiled column E has the same entries as column C, only that the entries in column C appear only one single time. Column E has more rows, because the entries are often repeated in this column. The information in column E relate to the values in columns F and G.
    Aim: I want to create new information for column D. All values (F and G) of one entry in C that relate to the same entries in E shall be added up in column D. That means whenever an entry in E matches the entry in C, the relating values to the entry in E (column F and G in the same row) shall be added up in the one cell next to the entry in C.
    E.g. on the spreadsheet: LAM: the region LAM appears one time in column C, but x-times in column E. All values (column F and G in the same row) for each time LAM appears in E shall be added up in cell D2. Subsequently the same procedure for all regions in C have to be repeated.

    Thanks so much for your help. My feeling says I have to use the “sumif” and “match” functions together, but unfortunately I have no idea how. Please ask if there are uncertainties. Abstract problems are very hard to describe.
    All the best
    Daniel

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,896

    Re: -Sumif- -match-: Values shall be added up if relating information matches with other c

    Do you mean this in D2?:

    =SUMIF(E:E,C2,F:F)

    If so, copy it down as far as you need to.

    Hope this helps.

    Pete

    EDIT: On re-reading your post, you might need this:

    =SUMIF(E:E,C2,F:F)+SUMIF(E:E,C2,G:G)

    Pete
    Last edited by Pete_UK; 11-22-2012 at 12:45 PM.

  3. #3
    Registered User
    Join Date
    10-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: -Sumif- -match-: Values shall be added up if relating information matches with other c

    i have solved your query in sheet 2.Find matches between two columns to insert third but related information into a new column(BB)_.xlsx

+ 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