Take a look SUMIF function in help menu

"lorik" wrote:

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?