Column 1    Column 2
Type X      5
Type Y      6
Type X      3
Type Z      9
Type Y      7

Each type, max of column 2, and then sum of all
Each type: Type X, Type Y, Type Z
Max of column 2: Type X=>5, Type Y=>7, Type Z=>9
Sum of all: 5+7+9=21