Hi,

Try to work with pivot tables. Drag column A to the rows area and column B
to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"lorik" wrote in message
...
Hi,
I'm trying to formulate a total from 2 columns. Column A has my item
letters(I have multiples), ex(B), and column B has the number of units.
My
new column I'm trying to total how many units I've sold of each item.


Can you supply the right formula to use?