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
Bookmarks