Okay so I thought about an alternative but I still need a bit of help. I thought about using a vlookup in combination so I have something along the lines of this:

ABER AM AB145-------ABER AM 5
ABER AM AB145-------ABER AM 4
ABER AM AB250-------ABER AM 3
ABER AM AB250-------ABER AM 5
ABER AM AB35--------ABER AM 3
AER 132--------------AER 2
AER 234--------------AER 2
AER 235--------------AER 1
etc.

But how could you create a graph that would combine the cells with the same name so that I would just have

ABER AM 20
AER 5

in a bar chart?

Thanks.