Basically there are a bunch of cells lets say A3, A6 & A9, which are fed by a this formula
=IF($AD2="","",VLOOKUP($AD2,Sheet2!$X$1:$AD$63,7,FALSE))

The result comes up with a number and a colour, for example, 2 Blue, 3 Purple etc.

What I am trying to do is to separate the number from the colour, so that I can add the numbers for each colour together (2 Blue & 3 Blue would give 5 Blue), in another cell which is currently =(A3&A6&A9), But I was going to change once I figured out this part...

The Spreadsheet itself is rather complicated, So I wont post it here, if I am not making myself clear I may try to mock something up for it when I get a chance.