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

1. ## -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. ## 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

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

Pete

3. ## 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

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

#### 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