Thanks that works great! but i have encountered a new problem.

I have a column with the values which is great but the cell to the right I specify a qty of say A1, C1 etc. Is there a way this count can work that out.
20 xA1
1 x A1
15 x A1
1 x C1
3 x c4

and count them?