Sum values

Hi

I am trying to SUM values in a column based on their code in other columns.

For example in column 1 ALBS_00003_11 has VMAINT and VMAJOR so I want to add these two values and show what the total cost is for these two values, BANS_00057_21 has VMAINT and VMAJOR so these should be added with the total shown and so on. So in effect if there is the same code in column 1 and this has a VMAINT and a VMAJOR these should be added together. Any code in column 1 that only has VMAINT should be excluded. I also need to show the overall total of these values that are paired.

Any help would be appreciated

Regards

John