CODEWITHSUNDEEP
excelexcel-formulamatchvlookuplookup
Materazzi23
Materazzi23

Reputation: 15

Excel Lookup and sum multiple values

A          B       C        D           D             E          F
DEForage201 DE  Deutschland 201 Perennial Ryegrass  Forage      789951
DEForage201 DE  Germany     201 Perennial Ryegrass  Forage      5617026

In the list above (starting in column A which is an ID line compiled by column B, F and D) I want to lookup and get the sum of the rightmost column.

Currently I am using vlookup and look for the ID line in column A, until I noticed that the country names in column C would differ during the list which is why I am having identical ID lines in column A and currently only get the first value.

Any ideas how to solve this?

Upvotes: 0

Views: 97

Answers (1)

DavidP
DavidP

Reputation: 623

Assuming you're looking for a way to view the sum of column F for each unique combination of columns A through E, a Pivot Table might be what you're looking for. You can select columns A through E as the "rows" for the pivot table, and sum of column F for the values. Adjust the report layout in the Pivot Table Design tab to get it to look the way you want.

Upvotes: 1

Related Questions